How to clear a cell when a box is checked - using automation

crystal.schroeder
crystal.schroeder ✭✭✭✭

Hello,

I have a reporting task list that shows days until due and days past due based on todays date. I also have a box that they can check once the task is completed. I am wanting the days past due and past until due column to clear once the box is checked. I tried doing this with an automation but it didnt work so i think I am doing it wrong.


2023-06-09_10-08-26.png 2023-06-09_10-14-05.png


Answers