Checkbox If Formula

kleinsb ✭✭
edited 12/09/19 in Formulas and Functions

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)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!