How to update past dropdown list responses with updated dropdown values?
Hi and thanks in advance for any help.
Is there a way to update dropdown values so that the previously captured responses within your sheet reflect the new values?
I'm finding that if I update a dropdown list value, for example list value "Open-Project", to simple read "Open" then my sheet and form automatically show both as drop down options going forward.
But what I actually want to happen, is for all previously recorded instances of "Open-Project" to simply change to just "Open" within my sheet, and for 'Open' to be the updated list option that appears in the list and forms going forward.
At the moment the only way i can see to do this is to manually one by one change the past responses in the sheet (which could potentially be thousands of instances in the future), select again the new updated list item ("Open"), and then go back into the column properties to delete the redundant list item now that no rows utilize the old list value.
Is there a smarter way to manage this challenge? as lists and options evolve or change overtime this can make updating sheets very complicated.