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
If I need the value from a Summary Sheet, to link it to the Intake sheet, is this how it should look like at the control center?
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
