Nested If Statements

Rookie here - can someone please tell me what I'm doing wrong?

=IF(AND([Started?]@row = true, (TODAY(20) > [End Date]@row, "Urgent", IF(AND([Started?]@row = true, (TODAY(7) > [End Date]@row, "At Risk", "Not Started")))



Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!