Formula with Multi-Select


#1

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.


#2

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}.