Allow a Global Update for a Reference
Options
Sarah123
✭✭✭✭
It would be nice if I could create a new reference in the template and have that reference added using the global updates. Right now I can push a formula out using the global updates but in order to have the formula work I have to go into each sheet individually to add the references.
Comments
-
YES PLEASE!!! THIS IS A MUST!!!! We have to do this a lot since our process changes constantly and we have over 200+ projects provisioned. We would love this function!
-
There are often times when I want to create a formula with a cross-sheet reference where that referenced sheet is always the same. I want a way to create a Global (reusable) range reference that anyone can use in their formula without having to define that reference in every sheet. For instance, let's say I have a central list of products and I have 100 different sheets which also have one or more of those products and I want to create a lookup formula in those sheets to return information about the products. In an ideal state, as a system admin I would create Global references for the various columns of data in that central sheet and then ANY user could reuse those global references in their formulas without having to set up the same cross-reference each time - Smartsheet would be able to recognize the {range} as a global reference and automatically direct the formula to the central sheet. I expect this would require that when a Global reference is created, it's name becomes reserved so it cannot be reused for a non-global reference. This is similar to how named ranges work in Excel.
We regularly have to build formulas in existing sheets with cross-sheet references and we have to set the exact same cross-sheet reference up every single time. This is a tremendous waste of time.
-
Agreed. It would be nice if we could add cross-sheet references using global updates in the control center.
Not for other users, this can be done in Bridge. I essentially run a parent workflow to find all of my active projects then run a child workflow on each to create the cross-sheet reference. I'm happy to share my method with anyone who isn't sure how to set it up.
-
Up on this! This is indeed a must. I also have issues on this where I need to update a thousand projects :(
-
I agree. This would save significant time and effort.
-
@jessica.smith Could you share your process on how to set this up in Bridge?
-
I created an example of one way to do this and wrote up some instructions with screen shots (attached). I'm honesly not sure how clear it's going to be, but feel free to direct message me if you want to set up a meeting to walk through or talk about how to apply to your use case.
-
+1 and yes please.
