Using GYR symbol for status nested if's
Hello,
Does anyone know how I can use the GYR symbols in a nested if condition? I am using three columns, the last one using the symbol to reflect the status. Here is my logic:
If column A has no text, show in column C nothing or "".
If Column A has "text" AND in column B has text, show in column C a green dot.
If column A has "text" AND in column B has no text, show in column C a red dot.
I am having trouble with the column B conditional. I always keep getting a red dot.
Also in column B  it is restricted to drop down YES only as an option. So I am not sure if the ISTEXT the correct formula to use.
=IF(ISBLANK([ColumnA]1,"",IF(ISTEXT(ColumnA]1,"Red",IF(ISTEXT(ColumnB]1,"Green")))
Any help will be appreciated.
Thanks,
Veronica
Comments

It will always stop on the 1st right answer. So If Column A has text, whether B does or does not, it will stop and give you the red dot. If B will only have text if A also does, you could just swap those two conditions, so it evaluates B column first before looking at A.

you should check this out:
https://www.smartsheet.com/blog/supporttipbuildnestedIF
once you have set the column type to stoplight, the text that appears next to the object when you click in a cell is the reference.
For a stoplight it is simply the color, "Green", "Yellow", "Red"

You could try something along the lines of
=IF(ISTEXT(ColumnB@row), "Green", IF(ISTEXT(ColumnA@row), "Red"))

Thank you everyone for the response. I did get it to work. I use the option to reverse check starting with Column B and then work my way out to column A. Works perfectly.
Thank you again!


I have my nested IF statement working correctly; however, my results only show the words green, yellow, red rather than the colored balls. I have changed the properties of the column to be the icons but I still have words.
Help Article Resources
Categories
Check out the Formula Handbook template!