Checkbox If Formula

kleinsb

Wondering if this is possible: I am trying to create an IF formula in a checkbox column where, based on the Start Date of one of the rows, if the date is in the future, it will not be checked, but if the date is today or in the past, it will be checked.  I was playing around with the below formula but it was not working.

=IF([Start Date]2<TODAY()1,0)

Dan Seidler

You're missing a comma after TODAY()

=IF([Start Date]2<TODAY(),1,0)

kleinsb

THANK YOU

Jeez I feel like an idiot for missing that, it's been driving me crazy!

Paul Newcome

You're also going to want to use <= to denote the " if the date is today" portion.

 

=IF([Start Date]2 <= TODAY(),1,0)

 

You can also leave out the ending 0 if you want, but that's just a matter of personal preference.