Using GYR symbol for status nested if's
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.
Any help will be appreciated.
Help Article Resources
Check out the Formula Handbook template!