Wasted a huge amount of time to try to find a workaround. Last attempt before I drop AppSheet alltogether:
I have an excel file with two sheets, one where I fill the data (and the sheet that AppSheet is working on) and the second one where I run some calculations on it. I am using tables on the 2nd sheet.
I have a table with the following values:
=D2
=D3
=D4
and etc.
But every time after syncing with AppSheet it will change all the cells in the column back to =D2
Every time I have to open the excel file and do RESTORE CALCULATED FORMULA to put it back to how it should be (=D2, =D3โฆ)
This happens in couple of tables. except one where it stays normal. I donโt know the reason for this. It doesnโt seem logical and looks like just a bug. AppSheet is not even syncing data to this sheet.
Is there a workaround for this or should I use another app and thatโs it?
Thanks
User | Count |
---|---|
35 | |
31 | |
30 | |
18 | |
17 |