Using GYR symbol for status nested if's

Veronica J

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

Nic Larsen

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. 

L_123

you should check this out:

 

https://www.smartsheet.com/blog/support-tip-build-nested-IF

 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"

Paul Newcome

You could try something along the lines of 

 

=IF(ISTEXT(ColumnB@row), "Green", IF(ISTEXT(ColumnA@row), "Red"))

Veronica J

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!

Paul Newcome

Happy to help. 

Annaleah Morrow

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.