Formula Help

Brenda Gonzales
edited 12/09/19 in Formulas and Functions


Need help combining these two formulas to calculate the # of days open from the date of entry. Not to include "Solution complete" or "Solution identified and agreed upon". 

=IF(NOT(Status@row = "Solution Complete"), (TODAY() - Date@row), "")

=IF(NOT(Status@row = "Solution identified and agreed upon"), (TODAY() - Date@row), "")

Thank you 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!