expression with dynamic column name

Is it possible to have expression with dynamic indirect column name?

Lets say we are having TEST table represented within google spreadsheet:

hunaism_1-1658430361243.png

Ok, and now I would like to change the value (from False to True) with an action. The Action is triggered during the DAY for the defined PERSON. 

So... the action triggered on 2021-07-22 for Eva should change the value in cell C4. Next day, on 23rd of July, when triggered for John should mark cell D2 to True. And so on...

0 12 1,251
12 REPLIES 12
Top Labels in this Space