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
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
I have an automation setup to escalate to managers when a step goes beyond 2 days. I have that titled as Escalation for Purchasing, Escalation for Planning, etc. In my trial run, 3 out of 6 showed up as Reminder: New part number request log ( this is the name of the sheet) The only thing we could see was that the ones that…
