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:
Airtable formulas can use either single or double quotes (' or ") in the same way as most programming languages. It is useful to alternate the quote type when you want to use a literal quote without having to escape it.