Maintaining multiple sheets with the same format

Julia C Peterson

I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a column or something) and it is very time consuming to do that to each individual sheet. Is there anyway to have a master template so that when I add a column to the master template, all of the individual sheets get the column added to them to?

Andrée Starå

Hi Julia,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use the Smartsheet API or the the premium add-on, Control Center.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/control-center

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Julia C Peterson

I might be able to get access to control center, but will that fulfill my need with this?

Andrée Starå

@Julia C Peterson

I'm not sure! I'll need more information to be able to answer that correctly.

Can you share some more details?