Updating (e.g. formatting) Sheets - Is there a better way?
I am 2 months new to Smartsheet and enjoying the journey thus far.
I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as desired, I plan to develop sheets for each service/department for supervisors and designates to update.
My question I was hoping someone may be able to assist with or point me in the right direction. Is there a better way? The issue I see that maybe there is way for this to automatically update? If say, down the road, we want to add an additional column, formatting, etc., would I have to then go into each department/service line sheet and make these same changes to each. I wasn't sure if there is a way that when you update a a sheet (in this case the master sheet), and if you ADD a Column (e.g. Cost Variance or color coded) that it would automatically update in all other sheets as well?
Another question, is there a way that when you add a row that the formula will automatically carry down or up?
Very much appreciate folks time, so thank you in advance for any feedback or best practices you have deployed!