How to Use a Formula Field as a Dropdown Filter in Your Airtable Interface

You’ve set up an automation in Airtable to record when a task or ticket is completed. Each time the Status field changes to “Done,” the Date Completed field captures the exact date and time.

That works perfectly for reporting, but when you want to group or filter by month in your Interface Dashboard, things get tricky.

You tried to simplify it by creating a Month Completed formula field using DATETIME_FORMAT({Date Completed}, 'MMM'), which neatly returns values like “Jan,” “Feb,” or “Mar.”

But then you realize you can’t use that formula field as a dropdown filter in your Interface.

So how do you make a formula field work as a dropdown in your Interface Dashboard?

The Simpler Approach

For your Month Completed field, you’re using a formula like DATETIME_FORMAT({Date Completed}, 'MMM') to display the month abbreviation.

Now, change this field’s format to a single select and manually add each month abbreviation (Jan, Feb, Mar, etc.) as options.

Once you do that, Airtable will treat the values as selectable options instead of calculated text. This means you can now use the Month Completed field as a dropdown filter in your Interface Dashboard.