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.