I am looking to have a status column show either
-Overdue
-Complete
-In Future
-Not Required
I have everything working except the Not Required.
=IF(AND([Skills Assessment | Due Date (Y2)]@row < TODAY(), [Skills Assessment | Date Completed (Y2)]@row = ""), "Overdue", IF(AND([Skills Assessment | Due Date (Y2)]@row > TODAY(), [Skills Assessment | Date Completed (Y2)]@row = ""), "In Future", IF([Skills Assessment | Due Date (Y2)]@row > [Skills Assessment | Date Completed (Y2)]@row, "Complete", "Not Required")))
