I’m working on an Airtable to track film festival submissions and I need help generating a formula.
I have two date fields, an “OPEN” date field and a “DEADLINE” date field. I fill in the day submissions open and when submissions are due.
If TODAY is after OPEN, then I’d like the field to say “OPEN”.
If TODAY is after DEADLINE, then I’d like the field to say “CLOSED”
Any help would be greatly appreciated. Thanks!