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

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.

ker9

Hi @crystal.schroeder

If you have a column formula set in your date columns I don't think automation will overrule that.

You can add something like this to your date formulas

IF(Done@row = 1, "", remainder of formula...

This will clear the date if the done box is checked.

Hope this helps!

crystal.schroeder

@ker9 yes perfect that worked! is there a way i can add in something that also crosses out the text in the rest of the row??

ker9

 @crystal.schroeder

You could use conditional formatting to apply a strikethrough format to the row when the done box is checked.