Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 08, 2019
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!