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/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"
-
You could try something along the lines of
=IF(ISTEXT(ColumnB@row), "Green", IF(ISTEXT(ColumnA@row), "Red"))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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!
-
Happy to help.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!