Hi – I may be in the wrong place, but if this is possible, am guessing it will be a script.
I have a single multi-select field with 450 options like:
United States, Automotive, P&L, Canada, Manufacturing
My team has gone through and categorized these into 3 new fields which would be:
- United States, Canada
- Automotive, Manufacturing
We have about 1500 records tagged in the first way. Is there a script I could run, that would redistribute those tags from the single field to the three fields, without creating new options?
Please let me know if this should be elsewhere. I searched for similar requests and didn’t find this. Thank you!