RYG formula in response to a numbered cell

I am having a bit of trouble figuring out how to write a formula to automate RYG symbols. Basically I want the rules to be as follows:

1. If value is less than 4, RED

2. If value is greater than 4 but less than 6, YELLOW

3. If value is greater than 6, GREEN

So far I have figured out how to do a single formula for 1 & 3 (written in the format of: =IF([13-Mar]1 > 6, "Green"), but not combined in the same cell and I have not at all figured out how to write the formula for 2.

I hope that all makes sense... I can clarify further if needed.

Any guidance will be extremely appreciated!

Find more posts tagged with

Formulas

Comments

Tom Holder

Try this, I got a variation in my sheet to work

=IF([13-Mar]1 <4, "Red", IF([13-Mar]1 =5, "Yellow", IF([13-Mar]1 >6, "Green")))

p_bureau

Hi!

What your are looking for is Nested If. In your case, this would look like :

"= IF([13-Mar]1 > 6, "Green", IF([13-Mar]1 > 4, "Yellow", "Red") ) "

Your should read this like : If [13-Mar]1 > 6 then Green, ElseIf [13-Mar]1 > 4 then Yellow, Else Red.

Hope this helps!

Paul.

rnye

That was exactly what I needed!

Thank you so much! You're a lifesaver!

-Ruby

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?