date range formula

Haleh

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!

Paul Newcome

Try this:

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

Paul Newcome

Try this:

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

Haleh

Thank you!

Paul Newcome

Happy to help. 👍️