This is my first time trying to create an app so I think this must be a very newbie issue that you guys all know how to solve.
I am testing my prototype app in editor with a One Drive Excel table that has several formulas for all the rows. They are the same formulas for every row but not IDENTICAL as they change the row codes to pick the cells of different rows but of the same column.
However, after I successfully put in and synced the editable data for the first row by the prototype APP, all the formulas of different columns become identical, which means they all become formulas of the first row as shown below:
How do I avoid this and keep formulas work for their own rows?