Checkbox If Formula

kleinsb · 04/04/19

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 · 04/04/19

You're missing a comma after TODAY()

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

kleinsb · 04/04/19

THANK YOU

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

Paul Newcome · 04/05/19

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.

Checkbox If Formula

Comments

Help Article Resources

Categories