Changing the name of a column in a rollup report

A&W Admin

Hi all,

I'm spinning my wheels here trying to find the answer to this question, and I'm hoping someone can help me. I have a rollup report that runs through Control Centre for our blueprint. I've had a request to update the column name in the rollup report to make it more explicit for the end user. However, if I rename the column in the rollup sheet, will I have to go to all of my source sheets and change the associated name in the row to match the new column name? I have close to 500 projects so I'm very reluctant to do this and have something break!

Yvonne Smythe

Hi @A&W Admin - I’ve had a request like this before when two stakeholders wanted different names for the same column. I created a new column that mirrored the old column, hide the old column, and redirected the pull for the new column by deselecting the old and selecting the new. Hope this is of some help.

A&W Admin

That's a great idea, thank you Yvonne! I'll see if this can work for our set up.

Yvonne Smythe

Most welcome! All the best.