Just want the checkbox to check if the date is past due

ASalmon

Hi All, 

I've got a basic spreadsheet that I need the have the "complete" box automatically check itself if the due date is 1 day past due. 

I know I can do this with an =IF formula, I just can't figure out how. Can someone help? 

Best!

J. Craig Williams

I assume you mean 1 day or more past due 

This works 

=[Due Date]23 < TODAY()

for row 23

This too

=IF([Due Date]23 < TODAY(),1,0)

Craig

tylermh

What if I wanted to also add a condition to this formula to only check the box when the "Status" column is not "Complete"?

Andrée Starå

Hi Tyler,

Try something like.

=IF(AND([Due Date]@row < TODAY(); NOT(Status@row = "Complete")); 1; 0)    

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

=IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 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 day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

tylermh

That worked perfectly! Thank you!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée