Checkbox If Formula

kleinsb
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)

Tags:

Comments

  • You're missing a comma after TODAY()

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

  • kleinsb
    kleinsb
    edited 04/05/19

    THANK YOU

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 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.

    thinkspi.com