How can we view the table column we see in the app but not on the spreadsheet database

Hi app sheet team ,

Basically i want a spreadsheet view of my current stock levels. Currently i have not got the current stock level column displayed in my spreadsheet. can anyone help with that?

my google sheet does not display current stock column

Here is the view i want to see in my google sheet. i want a column to display the current stock level

Does anyone have any ideas on how to display this would be greatly appreciated.

I suspect Current Stock column is virtual column instead of physical column. You need to create data fields in the spreadsheet, and push the same expression you currently have in VC into either initial value or app formula.

2 Likes