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

Find more posts tagged with

Formulas

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

JOIN COLLECT formula for multiple successors
This discussion was created from comments split from: Return a task name that corresponds to the row in the predecessor column.
SUMIFS with date and category referencing another sheet
Hi - I have a cashflow chart that I want to pull expenses into by category and month. The expenses are located on another sheet with a dropdown list that is the same on the cashflow chart. I have tried this formula but it is not returning the results - just $0.00 =SUMIFS({Expenses Amount}, {Expenses Category},…
Help with IF FIND Formula
This discussion was created from comments split from: How to collect multiple Successor values?.