date range formula

Haleh ✭✭
edited 06/28/23 in Formulas and Functions

Hi dear community,

I need a formula to return the values "Process" and "At Risk" when a certain date is reached.

I have a "Start date" column. I need to notify the assignee of the status for each task (all in separate columns). When we are 145-91 days from the start date, it should return "Process". When we are 90-0 days from the start date it should return "At Risk".

I tried the following mini formulas, which work. But I don't know how to combine them into one formula.

=IF([Start Date]@row - 91 > TODAY(), "At Risk")

=IF([Start Date]@row - 145 > TODAY(), "Process")

Any help would be greatly appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!