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?


Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    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")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!