Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula with Multi-Select

Topic Labels: Formulas
2438 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I use Airtable to track inventory sold on a variety of platforms.
One multi-select column notes if the inventory is Available, Sold, Donated, Trashed, etc.
In another column I note the date it was sold.

I’d like it to automatically mark it as sold if I’ve entered a date into the Sold Date column, but to still have the ability to mark the status differently if it is trashed, etc. Don’t want to add any new columns, but just make a formula.

1 Reply 1

Unfortunately, at the moment Airtable does not allow formula fields to evaluate to single- or multi-select values. (Are you sure you want a multi-select field here? Your options sound more single-select-ish…) You can come close to your intended design, but only by adding a column, and only with a caveat.

Your new field should be a formula field with this configuration:

IF(
    {Sold Date},
    {Sold Date},
    IF(
        {Item Status},
        {Item Status},
        BLANK()
        )
    )

The caveat is that if you use color-coding for select options, you will lose it when the formula field takes on the value of {Item Status}.