Hi! Iโm using a column that needs a spreadsheet formula.
When i first created the App the formula was wrong, but i didnโt catch it only until later. Iโve fixed it now, but Appsheet wonโt refresh the spreadsheet formula in the โSPREADSHEET FORMULAโ
definitions, so all the new record have the formula with the errors.
How can I force Appsheet to refresh the SPREADSHEET FORMULA in the definitions?
So far Iโve tried: - Regenerating (at least 10 times) - Deleting the column, then regenerating to โcaptureโ the delete, then add it again, then regenerate.
That didnโt work.
I really donโt want to delete the table and re-add it because I would have to re-work all the things Iโve customized so far.
Any help is appreciated, thanks!
David S
@David_Suescun Hi David, how did you change the formula in the spreadsheet? Did you change the formula for an entire column, or just in a few cells in the column? If you change the formula for the whole column, AppSheet should be able to pick up the new formula after you regenerate the table. Also, what data provider are you using (Google, Office365, etc.)?
If you need to force an AppSheet column to use a particular spreadsheet formula, you can simply delete the existing formula and put in a new one.
Hi @Harry ! I tried changing the formula for the whole column, but it didnโt work. I had to write in in RC
style (had to figure it out the hard way). Iโm using google sheets, Appsheet failed at picking up the formula by itself
At least it works now Thanks!
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |