Auto Checkbox Formula

americanfederal

Would you help with an auto checkbox formula please?

I want a checkbox to automatically check yes, if the sheet is 7 days past the created date and another checkbox in another column is not checked by the 7 day mark.

Andrée Starå

Hi,

Try something like.

=IF(AND(Created@row < TODAY(-7); Checkbox@row = 1); 1; 0)    

The same version but with the below changes for your and others convenience.  

=IF(AND(Created@row < TODAY(-7), Checkbox@row = 1), 1, 0)Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting