Text Returned based on a Date Coloum

I don't know if I am just unable to find the right question to ask in a search but I cant seem to find the right answer.

I have Text Column called "Health" and a date column called "Date Requested" which I write the date the task came in.

What I would like to do is:

If the "Date Requested" is 7 days in the past I want the Health to say "1 Week"

If the "Date Requested" is 14 days in the past I want the Health to say "2 Weeks"

If the "Date Requested" is 28 days in the past I want the Health to say "4 Weeks"

I tried the IF function and various solutions on here but they all use TODAY and I don't want it from Today, I want it from the "date Requested"

Thank you

Find more posts tagged with

Accepted answers

All comments

JO H

Actually, I think I have just worked it out

=IF(TODAY() > [Date Requested]@row + 28, "4 Weeks", IF(TODAY() > [Date Requested]@row + 14, "2 Weeks", IF(TODAY() > [Date Requested]@row + 7, "1 Week")))

Hope this is ok

Genevieve P.

Hey @JO H

Well done! I'm glad you were able to figure this out.

Cheers,

Genevieve

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.