how many items do you need to change?

if not so many, you could create a view that shows just items with old value in choice field.

then prepare in a excel a column with all the new choice values.

copy&paste new values from excel to list in a quick edit mode.

Thanks Marian!  There are quite a few, and to complicate things more, this is a multi-choice (checkbox) field, so some of the items have other choices selected in addition to the one value I need to change.

Hi Chris,

I guess there wont be an easy way and the approach you suggested might be the best possible option. I do think creating the workflow in Nintex to update this wont take that long.

If you had a lookup field then all the values in your list would have got updated as SharePoint stores only the reference to the lookup value but as this is choice field SP will store the actual value, so you would need to update all the values through some automation (Nintex or a PS script!). Unless there is someone who might have a OOB approach to do this in SP.

Regards,

Shrini

then I would maybe exported whole list to an excel, replace that single choice value, (cleared the list in SP) and imported it back to SP list.

for 2k+ items that shouldn't be a big deal.

only problem might be if you have any dependent lists/lookups on this list, since item IDs will change.

if this is as well not viable then the best approach really would be to create a small workflow that performs update.

Your first lesson from this should be to use Lookups where you can

Yeah multiple ways to tackle this. You could workflow it to lookup all ID's with the old name and using For Each ID, update to the new name.

Another way is to just use the edit option on your list. Just copy and paste into the field your new name.