If after submission open date, then open

Topic Labels: Formulas
657 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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