Is there a way to update the same cells on multiple sheets simultaneously?

Katie White

We have a test script library that has hundreds of scripts that refer to a navigation path to guide the tester through the system. The system UI has changed so the navigation path has changed and we need to update the scripts. We have multiple clients that already have these scripts added to their project workspaces as they are either in active testing or about to enter a testing cycle. The navigation paths are all on the same row and column. Is there a way to update these without manually accessing and updating every single script? Perhaps a 3rd party API can do it? We do not have Bridge or Data Shuttle, and I'm not even sure those could accomplish this anyway?

Andrée Starå

https://community.smartsheet.com/discussion/139689/is-there-a-way-to-update-the-same-cells-on-multiple-sheets-simultaneously

Hi,

I hope you're well and safe!

To add to Nathan's excellent advice/answer.

Another option could be to create reports and update all the values accordingly.

Would that work/help?

Additionally, I recommend exploring the Premium App's Control Center, which can simplify this process and offer many more benefits.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

SSFeatures

Hi @Katie White, you can accomplish this using the Smartsheet API with a script.

I'm assuming that the person who will run the script also has full access to all of the client sheets, otherwise they for sure would not be able to perform any updates to any of the sheets.

You'll need a programmer, or someone great with AI-based programming tools.

The script will do the following:

• Use List Sheets to get all of the sheets that the user has access to.
• For each sheet, use Get Sheet, to get the rows and columns.
• Check the row and column that should have the old text "Project Accountant > Project Management > Project List"
• If the cell has that old text, use Update Rows to update that cell with the new text.

If the user that runs this script has access to thousands of sheets, then this script could take a bit of time to run to completion. Smartsheet only allows 300 requests per minute per API token, so you'd need to make sure that you don't perform too many requests in a single minute.

I hope this helps!

Andrée Starå

https://community.smartsheet.com/discussion/139689/is-there-a-way-to-update-the-same-cells-on-multiple-sheets-simultaneously

Hi,

I hope you're well and safe!

To add to Nathan's excellent advice/answer.

Another option could be to create reports and update all the values accordingly.

Would that work/help?

Additionally, I recommend exploring the Premium App's Control Center, which can simplify this process and offer many more benefits.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Katie White

https://community.smartsheet.com/discussion/comment/485407#Comment_485407

Man, this community is wonderful! Thank you all for your quick responses. @SSFeatures your solution is the direction I was starting to head in, but I wasn't aware of the API call limit and the scripts do indeed number in the thousands, so that would definitely be a limitation. That and we have a limited number of folks who have the access, time and ability to make API calls, so I was hoping for something a little more streamlined.

Andrée - I think the suggestion to use a report for this will be the quickest and easiest solution, and it seems so simple I'm surprised I didn't think of it myself! We are testing it out currently but I wanted to extend my gratitude for your guidance! I'll also be filing this away on my running list of use cases for Control Center :)

Thanks for your help!

Andrée Starå

https://community.smartsheet.com/discussion/comment/485443#Comment_485443

Excellent!

Happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

SSFeatures

@Andrée Starå I learn so much from you :). A row report makes so much sense lol

@Katie White You're very welcome! The row report definitely seems like a nice straightforward option!