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

If after submission open date, then open

Topic Labels: Formulas
379 0
Showing results for 
Search instead for 
Did you mean: 

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!

0 Replies 0