Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Autopopulate a multiple select status field

Topic Labels: Automations
247 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi All,
I have an issue that I think would be simple to resolve, but so far has eluded me.
I have a table with a status column with 3 possible options, that stack on each other. What I would like to happen is for the status to be automatically set based on 3 date fields. I have found a way to automatically concatenate the 3 status based on the 3 date fields, using a formula, which is great, but the issue is that this formula results in a string that does not play well with the chart “apps” and I cannot visualize the counts of # of records with each status.
So I need the status to be in the multiple select format in order to be able to use them in the apps. But I cannot figure out a way to automate the population of the status the way I can with a formula. I tried to use automation based on the formula to fill in the multiple select field, but it only pulls in the “Acquired” status and creates blank statuses.

Any help would be appreciated
image

0 Replies 0