Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Formula for labeling events as Upcoming / Current / Closed

Topic Labels: Formulas
1214 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauren_Studebak
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: