Best practice for formulas and rolling out templates


Hi folks.

It strikes me that Smartsheet HAS to be set up right from the get-go, because if you get your template wrong and roll it out to your users, adjusting a formula, column name or any other duplicated variable is going to be a big pain to fix - you'd have to have all your users transfer their data onto your new "fixed" template - either a big pain for them, or for the administrator, especially in a big company.

What is best practice for this?

Is there a way of defining formulae outside a sheet and having them referred to indirectly so they can be fixed in a single go?

Is there a tool for transferring from old templates to new ones?

Is there a way to run copies of the templates as clones which adjust when the master template is adjusted?

I'm very mindful of rolling out and finding the next week I've found a problem in a formula, or have a request for a metric which hasn't been engineered into the template.

thanks in advance!

Best Answers