nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Using IF with RYG formula

styless · 2019-08-28T14:11:16+00:00

Hello I am trying to build a formula where: * If the "Date Entered" column is within 60 days, the "Req Health" stays Green * If it is 90 days or more, Req Health turns Yellow (I got this formula figured out) * 125 days or more, Req health turns Red. Sheet…

styless

Hello I am trying to build a formula where:

If the "Date Entered" column is within 60 days, the "Req Health" stays Green
If it is 90 days or more, Req Health turns Yellow (I got this formula figured out)
125 days or more, Req health turns Red.

Sheet sample: https://app.smartsheet.com/b/publish?EQBCT=a7cfbf9d93ba41c7bccefd8366c8553c

I am just not sure how to combine all the ranges and formulas as I have tried different way and came up with Errors.

Pls help. Thanks in advance!

Find more posts tagged with

Formulas

Comments

James McCombs

Hey, styless!

I think I've mostly sorted out your issue, but I tweaked the formula a bit because it looks like you had a gap between <60 being Green, but >90 being Yellow. I changed the Yellow value to kick off at 61 days Let me know if this works!

=IF(TODAY() - [Date Entered]1 <= 60, "Green", IF(AND(TODAY() - [Date Entered]1 <= 124, TODAY() - [Date Entered]1 >= 61), "Yellow", IF(TODAY() - [Date Entered]1 >= 125, "Red", "Null")))

P.S. I added a "Null" text value, just in case there were any hiccups. If you'd like to get rid of it, just change it to:

=IF(TODAY() - [Date Entered]1 <= 60, "Green", IF(AND(TODAY() - [Date Entered]1 <= 124, TODAY() - [Date Entered]1 >= 61), "Yellow", "Red"))

styless

Thank you so much. It worked like a charm!

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Issues
The dashboard previously contained 16 widgets, and I have confirmed that the widgets still exist in the backend. However, when I open the dashboard, nothing is displayed, and I am unable to enter Edit Mode or access the widgets/data sources. I have already confirmed the following: I am the owner of the dashboard and have…
Add time to end date
I have an end date column and want to add 30 days to that for a new column that shows due date. How do I add 30 days to a date automatically?
Uploading Excel sheet to Smartsheet
Why is it so convoluted now! I eventually figured out the changes and ended up with a sheet that Smartsheet completely reorganised the rows and the sheet is now useless to me as it is not in a logical order for me to easily restore to its original layout. This is not an "improvement"! It was far easier to upload data…