nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

'Find & Replace' functionality in SmartSheet?

tracy.earwaker91531

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

Find more posts tagged with

Workspaces

Sheets

Reports

Conditional Formatting

Project Management

Cell linking

Comments

Andrée Starå

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

tracy.earwaker91531

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

Andrée Starå

Happy to help!

Another option could be the Smartsheet API.

More info: http://developers.smartsheet.com/

Hope that helps!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…