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

HK Quality Service Group

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".

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