I have a spreadsheet with a remote datasource, linked via the .read() function of the datasource.
I would like to add a formula to a specific cell on each row (over 5000 rows).The cell config is called "pageWeightValue". The datasource.data() method is an array on my objects, where each object has an attribute called pageWeightValue. Is there a way to set the value in the array to the formula. The column is set to type string, but the formula is not applied as a formula, but rather an actual string. Ie for each record in my array I do object.pageWeightValue = '=sum(A1:A4)' (the letter changes dependant on the row number). However in the cell I set the exact string, rather than the formula result.
Thanks!
Marc