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
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!