Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
