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

Options

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!