Within an IF Formula, recognizing a date prior to.

M. David
M. David ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I have created a formula to indicate the status of our project based on today's date and if it has met the date each phase is completed. 

=IF(TODAY() > Date82, "Operational", IF(TODAY() > Date77, "Pre-Operational", IF(TODAY() > Date72, "Under Construction", "In Development")))

The phases were put in reverse, to accommodate the order of how the IF formula evaluates. The issue I am having is where I have "IF(TODAY() > Date77". I don't want that phase based on a date, but rather would like to have it be 60 days prior to "Date82". Is there a way of doing this? I know you can add in before and after to the TODAY function, but I can't wrap my head around how that would accomplish my goal. 

All help is appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!