Method/formula to rename sheets, reports and dashboards in a folder

Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and dashboard.

Excel has a formula to automatically update chart titles based on new month etc.. Am looking for a method or formula that will utilize the new project name replacing the generic (Clear), in each of the sheets, reports and dashboard in the folder.

Example "(Clear) System Access Status Report" for the ABC project to "ABC System Access Status Report".

Find more posts tagged with

Sheets

Healthcare

Formulas

Project Management

Comments

Paul Newcome

THere is no way to do this within Smartsheet itself, but it may be possible with either a 3rd party app such as Zapier or with the API.

PPS Solutions

Hi we have a Forms app built on the Smartsheet API which automates what you have described in seconds as well as a customisable interface to add summary field info to each sheet eg Project Manager Name, Sponsor name, Approved Budget etc. If you would like a screenshare demo drop us a line - solutions@projectplanservices.co.uk Cheers Dan

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…