Sign in to join the conversation:
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!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
Thanks
Tracy
Happy to help!
Another option could be the Smartsheet API.
More info: http://developers.smartsheet.com/
Hope that helps!
Andrée
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
