I have a custom field that is for "departments." Recently two of our departments merged and I need to change it to be "e-commerce" instead of "Content Team." That's the easy part, the hard part is how do I do this for past projects so that at the end of the year I can pull an accurate number of projects that we did for that department?
In the past I've had to do it all manually but I'm hoping to avoid that. Appreciate your thoughts and recommendations, thank you.