I was trying to change the previously written values to the spreadsheet but I haven’t succeeded yet.
I have a few virtual columns
[a.virtual] [b.virtual] which contains complex formulas that calculate the previously added rows and the rows will be added. These virtual columns are recalculated naturally, every time I sync the app.
In app formula for normal columns
[A] [B], I used virtual column names.
So, In the app, I always view the latest values for virtual columns correct. But in the spreadsheet the values are correct just for the lastest rows, the values for the previously added row aren’t changing. They should be the same as the previously added rows.
How can I change on the spreadsheet, the previously written values with the latest values of these virtual columns?