I have created an inventory app, and most fields are formulas except for one for POs Received and Manual Count. The app currently allows the user to update a few formula-driven cells, like my ‘Qty on Hand’ column, which is a sum of PO’s received plus Manual Count (I don’t want users to be able to update Qty on hand, as this should only be a formula). I would like to block this Column from editing capability, but still show up on the app. My other formula-driven columns seem to be blocked like I want them on the app, but there’s a couple that aren’t. So, that makes me think it’s a setting somewhere in appsheet (that I can’t find) rather than appsheet picking up on the fact that it’s a formula in the spreadsheet and not allowing edits. Suggestions?
LinkedIn
Twitter
