date range formula

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!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.