How can I identify multi-select cell values that are not in the dropdown list?

Bailey Neal

I have a multi select column "Cost Code." There are currently values in the column that are not within the dropdown list.

For the "Accessory Code" I was able to check and flag these via the following formula where I reference a column in a separate

=IF(CONTAINS([Accessory Type]@row, {A&A Column Selections Range 1}), 0, 1)

However, the same formula for a multi select column does not work. It is returning all values as false.

Malaina Hudson

Hello,@Bailey Neal.

This may not be a direct answer to your question, but since I also experience the "stragglers" in drop-downs, I've used 2 approaches to housekeeping on this dependent upon my user groups.

1. Users with high risk of variability to list - I added an Other to my main list and a second column for them to define their Other. Then I locked my list to only allow list items. I have a weekly schedule to go in and validate the Other, and add them to the list if they are more than one-offs. Locking the list prevents people from typing in free-form responses.
2. Users with a low risk of variability to list, I left the multi-select unlocked, but I have a housekeeping item weekly to check the list for variants and then to add them to the list. The mechanism I use for is simply to convert the column to Text/Number format, then turn it back to Multi-Select format. The only gotcha I've found in this method is the risk of multi-word entries to mean one thing that may be converted to one-word items in the list.

Bailey Neal

Thanks Malaina. I was hopeful there was an explanation why the contains function didn't work as it seems to me that it should, or that there was an alternative formula that might solve the problem