Random Column is Missing Data

[Qiro]

I have one column that Appsheet reads as empty, but the data is there in the spreadsheet.

It is the same all the way down. What's weird is the data is pulled through in certain places in the app.

There's no Show_If statement, no validity or anything else. It should just be a list of numbers.

Any ideas?

[Joseph_Seddik]

First, try to do a "Regenerate Structure" in your table. Let's see if it would get the problem solved.

[Qiro]

No luck, sadly. 

What I'm struggling to get my head around is that despite the column data not showing in the 'Show Data' view, it pulls through to one of the views that is a slice of that same table.

At the same time, if I refence that column in the table the sums always come back as 0 because it says there's no data there.

[Qiro · Accepted solution]

I'm not sure why, but I had to rename the column before AppSheet would recognise there was any data in it.

Seems to be working now!