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:
IF(AND(IS_BEFORE({Due},TODAY(),STATUS!=complete),‘ ’,‘
’)
What am I doing wrong? Please help a newbie. Thank you in advance!