Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?



Hi Tracy,

Interesting use case, how would you like to use it?

I don't know if it's possible with Dynamic View, but it's possible with Control Center.

Would that be an option?

Have a fantastic week!


Andrée Starå

Workflow Consultant @ Get Done Consulting

In reply to by Andrée Starå

Hi Andree

Thanks for your reply - much appreciated!

Here is what I am trying to achieve: 

We have 20 Workspaces, each Workspace has a Sheets folder which contains a template Project Plan in it. I would like to change a column heading from Go/No Go to Stage Gate 3 in each of the Project Plans. Instead of going into each of the 20 plans in the 20 Workspaces individually, is there a way that I can search for the Go/No Go column across all sheets in all workspaces and then update the column once so that the change updates across all 20 plans.

I am reading the link to the Control Centre to see if it will help.