Unable to Update or Add to Table

AppSheet AppSheet Q&A
1

I have a Table which imports from a Google Sheet. I have it set to allow Updates, Adds, and Deletes. Delete seems to work but, when I try to Update, the row is greyed out. When I try to Add, I just get a black screen. There are no error messages.

Thanks

2

My first guess would be that some of your sheet formulas might have been auto transfered/adapted to appsheet formulas. Check for existing formulas in appsheet columns definitions. In Gsheets, the same cells can be edited, or are they formula generated? You can’t edit a cell in appsheet if it has a formula in it in Gsheets

3

Please post screenshots that show the problems you mentioned.