Hi there,

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?

For example,

| 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?

= getValueFromVariableName(thisRow.day)

like `eval`

function in JS.

Hope to get some insights here.

Thanks.