Automation between columns

[K2]

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.

Thank you in advance!

[Pascal_Gallais- · Accepted solution]

Hello,

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

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

Regards,

Pascal