Posted 1 September 2019, 11:10 pm EST
Good morning/evening Sharad,
The snippet does work correctly, however there are a couple of issues,
try within your code sample to:
-
modify the value of a cell using a formula e.g. set to Bob within the isAdult column something like “=IF(B2)”.
-
after the first step try to update the text to “=IF(B1)”.
The formulas are not being applied, the cell prints out the text instead of evaluating the formula and furthermore the update of the same cell doesn’t work when a formula text is applied.
In general the formulas are not being evaluated correctly.
Let’s say we add a new row within the spreadsheet which doesn’t contain custom cell type and has a formula applied that refers to custom cell types the output doesn’t show