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!
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
What if I wanted to also add a condition to this formula to only check the box when the "Status" column is not "Complete"?
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
That worked perfectly! Thank you!
Excellent!
Happy to help!
Andrée
