Formula help: =IF with dates and single-select dropdown

Benjamin Brunnette

Hi Community,

I'm trying to create an =IF statement with a date column and single-select dropdown column to achieve the following output:

• If the input date is greater than 30 days in the future, select "Future" from dropdown
• If the input date is less than 30 days in the future, select "Upcoming" from dropdown
• If the input date is less than today's date, select "Past" from dropdown

Thanks for the help!

Paul Newcome

Try this...

=IF(Date Column]@row < TODAY(), "Past", IF([Date Column]@row < TODAY(30), "Upcoming", "Future"))

Paul Newcome

Try this...

=IF(Date Column]@row < TODAY(), "Past", IF([Date Column]@row < TODAY(30), "Upcoming", "Future"))

Benjamin Brunnette

That worked perfect - thanks so much!