when I set a formula, the formula is applied to all rows of the column.
Is there a way to put different formula per cell?
| Monday | a + b |
| Tuesday | c + d |
| Wednesday | e + f |
So far I haven’t found a way.
IF it’s not possible with coda,
I was thinking… I could just make variables,
Monday = a + b
Tuesday = c + d
Wednesday = e + f
but, when I want to get the values dynamically,
for example, let’s say there is a table with “day” column, and for the second column I want to get the values from the variables,
is there a way to set a formula for the second column like the following?
eval function in JS.
Hope to get some insights here.