If it's blank, Red Symbol. If it's not blank, Green symbol.
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?
Tags:
Best Answer

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")
Answers

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")

Thanks @Sameer Karkhanis That worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!