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
Solved
Removing a tag from many records
Best answer by kuovonne
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.
+27Delete 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?
+27Won’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.
+29Yes, 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.