First of all, apologies if this seems like a duplicate question, but the solutions to the other posts weren’t working for me.
Every time I hit save, the checkbox for ‘Key’ changes back to ‘_RowNumber’ and I receive an error for not having an ‘ID’ column, when I do.
Background:
A previous version of this worked, but I deleted an unnecessary column (Not the ID column) and regenerated the schema. Then I started working with Dec2Hex on the sheets side to get Key/ID’s assigned to all my rows. Once I did that, AppSheets got upset. I have since removed the Dec2Hex formulas on the Sheets side, and have tried changing the column type to ‘Text’, ‘Number’ and ‘None’ on the Sheets side, as well as the corresponding ‘Text’ and ‘Number’ types on the AppSheet side. All is producing errors referring to ‘Sheet Formulas’ that are no longer there.