If it's blank, Red Symbol. If it's not blank, Green symbol.

Nicole Endsley

I'm trying to get this formula to work correctly.

=IF(NOT(ISBLANK([Link to ARP plan]@row)), "Yes", IF(ISBLANK([Link to ARP plan]@row)), "No"))

It's not working. Any thoughts?

Sameer Karkhanis

Make sure your column type where you are using the formula is defined as Symbol column type and with the R,G,Y statuses. Use the formula below,

=IF(ISBLANK([Link to ARP plan]@row), "red", "green")

Sameer Karkhanis

Make sure your column type where you are using the formula is defined as Symbol column type and with the R,G,Y statuses. Use the formula below,

=IF(ISBLANK([Link to ARP plan]@row), "red", "green")

Nicole Endsley

Thanks @Sameer Karkhanis That worked!