Skip to main content

I have a multiple choice column.


Many records have a particular tag.


I can filter on another field to get a subset of those records.


How can I remove that particular tag from all of those records

Delete that option from the field’s configuration.

Delete that option from the field’s configuration.


Won’t that delete it from EVERY record, not just the subset I have filtered to?

Won’t that delete it from EVERY record, not just the subset I have filtered to?


Yes, I thought thats what you wanted.


You could create a formula field that is something like this:


SUBSTITUTE({Multiselect field}, "Whatever the tag is", "")


Then fill the multiselect column with the values from the formula field.

Yes, I thought thats what you wanted.


You could create a formula field that is something like this:


SUBSTITUTE({Multiselect field}, "Whatever the tag is", "")


Then fill the multiselect column with the values from the formula field.


After you create @Kamille_Parks’s formula field, copy the result of the formula field back into the multi-select field that you want to change. Then you can delete the formula field.

Reply


Terms & Conditions