I have loaded data from my excel worksheet and it mostly looks good but some columns come up with the correct header but no data. I just get blank cells. I can’t find any pattern to it. I have confirmed that my column fields are all formatted correctly and identically. In some cases I have two columns that are almost exactly the same, one’s data loads and the other’s doesn’t. I can copy the formula from a column that has loaded properly and then the data comes into AppSheet but it is using the wrong formula so I edit the formula in Excel to point to the values I need and then on reloading, the fields are blank again.
Hope you can help.