Nested If Statements

heather.adams

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")))

Paul Newcome

Try this...

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

Paul Newcome

Try this...

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

heather.adams

It worked perfectly! Thank you so much!!!!

Paul Newcome

Happy to help. 👍️