AppSheet ruining the calculated column formula every time it updates

[whatever61]

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?

[Marc_Dillon]

Recommend to not use spreadsheet formulas, especially ones that are super simple to convert to Appsheet expressions like simple division.

https://help.appsheet.com/en/collections/377977-expressions

[WillowMobileSys]

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

[whatever61]

I read it and it seems correct to me.
However this is my formula, maybe you see a problem in it?

=IF(L2="",M2/1.05,L2)

The 1.05 is the only fixed value. Could that be the issue?

[WillowMobileSys]

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.