Sign in to submit new ideas and vote
Get Started

Allow a Global Update for a Reference

Options
Sarah123
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.

36
36 votes

On Wishlist · Last Updated

We are actively thinking about how we can accommodate these concepts, including allowing direct updates to templates with cross-sheet references and eliminating the need to individually adjust sheets for column formulas. We don't have an ETA, but when we believe we can make this a reality we'll update the status here.

Comments

  • jessica.smith
    jessica.smith ✭✭✭✭✭
    Options

    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.

  • Steph Quijano
    Options

    Up on this! This is indeed a must. I also have issues on this where I need to update a thousand projects :(

  • Alan Buss
    Options

    I agree. This would save significant time and effort.

  • Falan Rowe
    Falan Rowe ✭✭✭
    Options

    Recently, we had to do an overhaul to some of our columns in a project blueprint which consisted of about 8 columns needing an index-match formula added. We had about 40 projects to edit. Adding the index-match formula manually was painful.

  • Rachel Beck
    Rachel Beck ✭✭✭
    Options

    @jessica.smith Could you share your process on how to set this up in Bridge?

  • jessica.smith
    jessica.smith ✭✭✭✭✭
    Options

    @Rachel Beck

    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.


  • jbaltao
    jbaltao ✭✭
    Options

    +1 and yes please.

  • Chizu Hieida
    Chizu Hieida ✭✭✭✭✭
    edited 05/27/24
    Options

    Hmmm…. I don't know what happened to my submission for this new product idea back in 3/14/2023. (Link: https://community.smartsheet.com/discussion/102630/global-cross-sheet-references/p1?new=1
    I know it was active a while since my coworkers voted on this link….

    It has been deleted.

    100% Agree on @Falan Rowe

    Here is what I submitted in this New Idea section (Mar 2023):

    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.

    Impact:
    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.

  • Chizu Hieida
    Chizu Hieida ✭✭✭✭✭
    edited 05/27/24
    Options