Basic question: can values calculated in virtual columns be assigned back into the database spreadsheet?
More info: I’ve got a typical inventory setup, with a list of inventory adjustments that refer back to any single inventory item. Then the actual amount is calculated by summing up the “related…” column. I would like that calculated amount to be in a column in the actual google spreadsheet as well. I’ve added the SUM formula into the column where I want the data, and it mostly works in the app, but the column remains blank in the actual spreadsheet.
Why do I need this? I want to run a script in the google spreadsheet that acts on that data. It is possible I can do what I need in the app, but the script is easier for me, and makes more sense.