Health Symbol Formulas


I am trying to write a formula to populate a RED health symbol when the Date closed is blank and the days open is greater than 14 any suggestions/ideas of what is wrong with my formula?

=IF(ISBLANK([Date Closed -Quality]@row, IF([Days Open]@row, >14, "Red")))

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!