Yes, this is a known behavior in AppSheet: when a new row is added via the app, it overwrites the entire row in Google Sheets, including any formulas like =PROCX (or =XLOOKUP, =ARRAYFORMULA, etc.) that might be in the sheet but not managed within AppSheet.
Even if the cell is marked as uneditable in the spreadsheet or protected, AppSheet still writes a full row of raw values, replacing what's in those cells.
WORKAROUNDS:
1. Use AppSheet formulas instead of Sheet formulas
If your PROCX formula is retrieving related data (like a lookup), try to replicate it with AppSheet's own expression language:
LOOKUP([_THISROW].[Column], Table, KeyColumn, ReturnColumn)
This keeps everything inside AppSheet and avoids formula loss.
2. Use an "arrayformula" on the Google Sheet
Instead of writing formulas row by row, write the formula in the entire column, starting in the first row below the header:
=ARRAYFORMULA(IF(A2:A="", "", PROCX(A2:A, ...)))
This way, the formula auto-applies itself to new rows and won't be overwritten because AppSheet doesnโt touch the formula in the column header row. Only remember to regenerate your table after applying the formula.
3. Use a Google Apps Script to re-insert formulas
Write a script that monitors new rows and re-applies the formula automatically. It's more complex but powerful in special cases.
This answer was generated with ChatGPT and reviewed by me! ChatGPT knows very well how to use AppSheet and can be very useful in cases like this one ๐
LinkedIn
Twitter
