Imbedded If Statements


I'm trying to use a formula (below) that will:

1)If a deviation was Approved, it is past its End Date...if Past End Date return "Expired", if not return "Active"

2)If it was never Approved, return "Rejected" need to evaluate if it is past its End Date.

My formula is returning Rejected only.

=IF([Approval Status]@row = "Approved", IF(TODAY() > [End Date]@row, "Expired", "Active"), "Rejected")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!