Assuming the formula in column A is:
A1/B1
A2/B2
A3/C3
and etc..
After each refresh AppSheet will ruin it and make all of them A1/B1.
The formula is already inserted in the excel itself. I don't need AppSheet to make any changes to this column at all.
Anyone has an idea how to do that?
Recommend to not use spreadsheet formulas, especially ones that are super simple to convert to Appsheet expressions like simple division.
Maybe these two articles can help explain?
https://help.appsheet.com/en/articles/961393-spreadsheet-formulas
https://help.appsheet.com/en/articles/3326638-mismatched-spreadsheet-formulas
My strong recommendation, as mentioned by @Marc_Dillon, since you are pulling these into AppSheet any, is to eliminate the sheet formula and use AppSheet expressions to handle it.
If you must use sheet formulas, please note that your formula is NOT in R1C1 format. Review the attached articles again. One of them goes into some detail about converting to R1C1 format.
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |