Using GYR symbol for status nested if's

Veronica J · 03/15/19

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 · 03/15/19

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 · 03/15/19

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 · 03/15/19

You could try something along the lines of

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

Veronica J · 03/15/19

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 · 03/18/19

Happy to help.

Annaleah Morrow · 07/28/21

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.

Using GYR symbol for status nested if's

Comments

Help Article Resources

Categories