Best practice for formulas and rolling out templates
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!