I have a SharePoint list that has a column called "Rev Due" which is a set due date. I have a calculated column in this list called "Overdue". In the formula for this column I have this code:
It works great. It displays "Yes" if the date is overdue. I need to add one more condition. I have another column called "Status". I need it to only display "Yes" if the Status is also "Not Started". I cannot figure out how to make SharePoint accept the second condition.
I tried to modify this example found online as a base but I can't get it to work:
=IF(AND([Column1]>[Column2], [Column1]<[Column3]), "OK", "Not OK")
End result needed: The word "yes" only displays if the date is overdue and the status is "not started".