I am monitoring a project. It has a field for due date (DUE) and a dropdown select field for status (STATUS). I would like to create a formula that would alert me if the Due Date has passed but the task STATUS is anything except “complete”. I am trying this formula but its not working:
What am I doing wrong? Please help a newbie. Thank you in advance!