Checkbox If Formula

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)

Find more posts tagged with

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Contact List showing as a text only
It happened suddenly. It was working last week. I'm using Index Collect to pull a contact as cross sheet reference. But today, I did not see that working well. Usually it has circle beside my name, suddenly it vanishes, and it just contains text. I'm using those other columns to be sent notification, and it doesn't work…
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…