Check Box If "Due Date" is in the Past and Keep Box Unchecked If Not
Hello,
I am wanting to use a simple formula that will check a box if the "due date" column is in the past while also keeping it uncheck if the date has not past. I am assuming I will use the IF formula, but not sure how to write this.
Thank you,
Ryan Holguin
Best Answer

=if(duedata@row="",0,if(duedate@row<today(),1,0))
if due date is blank it will remain unchecked
Answers

in your checkbox column try something like =if(duedate@row<today(),1,0). 1 will check the box 0 will uncheck the box.

@Samuel Mueller  Thanks! That helps a little. However, when I have certain tactics with no due date entered this formula will assume the date is in the past and checks boxes when I want them blank. How would I bypass this?

=if(duedata@row="",0,if(duedate@row<today(),1,0))
if due date is blank it will remain unchecked
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 429 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!