Text Returned based on a Date Coloum

Hi

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!