Using GYR symbol for status nested if's

Veronica J
edited 12/09/19 in Formulas and Functions

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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!