Check Box If "Due Date" is in the Past and Keep Box Unchecked If Not

Ryan Holguin

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

Samuel Mueller

=if(duedata@row="",0,if(duedate@row<today(),1,0))

if due date is blank it will remain unchecked

Samuel Mueller

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

Ryan Holguin

@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?

Samuel Mueller

=if(duedata@row="",0,if(duedate@row<today(),1,0))

if due date is blank it will remain unchecked