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.