Checkbox If Formula

kleinsbkleinsb
edited 12/09/19 in Formulas and Functions
04/04/19 Edited 12/09/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)

Tags:

Comments

  • You're missing a comma after TODAY()

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

  • kleinsbkleinsb
    edited 04/05/19

    THANK YOU

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

  • Paul NewcomePaul 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

Sign In or Register to comment.