Help

Automation between columns

Topic Labels: Automations Formulas
Solved
Jump to Solution
316 1
cancel
Showing results for 
Search instead for 
Did you mean: 
K2
4 - Data Explorer
4 - Data Explorer

Hello

I would like to know if it is possible to build an automation --> if Column B (Actual timeframe) changes and does not match with Column A (Initial timeframe), then the Column C (On time?) would change to YES or NO (single select option YES/NO)? Additionally, the actual timeframe value comes from Miro board.

K2_0-1724249565350.png

 

Thank you in advance!

 

1 Solution

Accepted Solutions

Hello,

If I understood corectly your request, a formula should do the job:

Pascal_Gallais_0-1724251013798.pngPascal_Gallais_1-1724251030731.png

You can also go on the "formatting" tab of the formula to turn the result as a single select.

Regards,

Pascal

 

See Solution in Thread

1 Reply 1

Hello,

If I understood corectly your request, a formula should do the job:

Pascal_Gallais_0-1724251013798.pngPascal_Gallais_1-1724251030731.png

You can also go on the "formatting" tab of the formula to turn the result as a single select.

Regards,

Pascal