Formula for labeling events as Upcoming / Current / Closed

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

Hi there,

I’m new to Airtable formulas, and I’m having a difficult time constructing a nested if formula that automates labeling events as open, upcoming, and ended. All items have an Opening and Closing date entered in their respective fields, and I’m hoping to have them but I can’t seem to compare them to today’s date accurately - does anyone have any suggestions?

1 Reply 1

Check this: