Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Cell linking from Report?

JLC
JLC ✭✭✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

Hi all,

I have a question and/or suggestion regarding cell linking. I have a master sheet that needs to pull cell links from multiple sheets which have very specific parameters. The sheets that we are pulling the cell links from all contain vast amounts of data, so we've created a report to pull the specific data that we need. However, there doesn't seem to be a way to cell link from the report to our master smartsheet. This would be of great use to us instead of having to hand-pick the specific rows we want from each sheet to link into the master.

 

Any chance this could be implemented, or does anyone have a workaround? Our master sheet cannot be a report or I would have done so.

Tags:
· Share on FacebookShare on Twitter
«1

Comments

  • Travis
    Travis Employee
    edited 11/03/15

    Good question, Jaye! There is not a way to cell link from reports (just to and from sheets) but I will submit this request to our enhancement request list and it will be considered for future development. 

     

    Thanks! 

    · Share on FacebookShare on Twitter
  • JLC
    JLC ✭✭✭✭✭✭

    Thanks Travis, it would ve very helpful for our team! The current cell linking process is powerful, but cumbersome when having to link many things at once - we do this a few times a month; on a daily basis we only need to find one or two cells which of course doesn't take much time.

    Thank you again, we love Smartsheet!

    · Share on FacebookShare on Twitter
  • Michael
    Michael ✭

    Please add my vote to enhancement/bug fixing request for this. 

    · Share on FacebookShare on Twitter
  • JLC
    JLC ✭✭✭✭✭✭

    Glad to hear we're not the only ones :) Would still love this to be implemented in the future. We've also discovered that it will help us when working with business partners who do not use the same template or column structure as our sheets. If we could cell link from a report, the report could pull the data we need and be organized in the structure that we prefer, then the whole row linked instead of having to link individual cells over and over and over again. :)

    · Share on FacebookShare on Twitter
  • Brad Jones
    Brad Jones ✭✭✭✭✭✭
    edited 10/21/16

    +1 here.

     

    Reports don't allow formulas, so I either have to do a LOAD of non-continuous cell linking, or I have to hide my formulas in cells on the master sheet.  Problem is, that the master sheet is what everyone subscribes to for their daily notifications, and notifications do not respect hidden columns so formulas and calculations make it into the daily emails because the formulas recalculate with every change.

     

    Sure would be good to be able to extract things using a report, and then link the report to another sheet where I could do my calculations outside of the master sheet.  This would also make my notifications MUCH more readable.

    · Share on FacebookShare on Twitter
  • Patricia Thurston
    Patricia Thurston ✭

    Yes, please allow us the ability to link from a report. 

    · Share on FacebookShare on Twitter
  • Amro
    Amro ✭
    edited 06/19/17

    +1 here.

    · Share on FacebookShare on Twitter
  • Billy Fadli
    Billy Fadli ✭✭

    +1 here too..

     

    I've got almost the same situation..

    1. need to get linked from report... OR

    2. need to get the copycat sheet (automatically update ALL).

     

    Thanks.

    · Share on FacebookShare on Twitter
  • Lindi Deguara
    Lindi Deguara ✭✭

    We are in the same position - being able to cell link from a report would provide great efficiencies and certainty of accuracy of information for our business. Has any progress been made on this, 

    · Share on FacebookShare on Twitter
  • Lexington
    Lexington ✭✭
    edited 04/04/18

    + 1 here! I guess no plans to do this as the original post is from 2015?

    · Share on FacebookShare on Twitter
  • oberning
    oberning ✭

    +1 here as well! Insane that this has been an ongoing issue for 3 years with no answer as to when/if it will be implemented!

    · Share on FacebookShare on Twitter
  • lumorrow
    lumorrow ✭

    Would love this feature! I have to cell link manually it takes so long!

    · Share on FacebookShare on Twitter
  • Mr.Hyde
    Mr.Hyde ✭

    I would also very much like to see this feature

    · Share on FacebookShare on Twitter
  • Brad Jones
    Brad Jones ✭✭✭✭✭✭

    You know...

    Lack of visible attention to old issues is a common thread here.  SS has historically been pretty good with at least participating in the posts - but I think there must be something wrong with the way their system handles updates to "old" items.  

    The moderators change every other year or so, and this may be why the new ones don't see it.  They were never 'attached or subscribed' to the existing ones.

    Not trying to give them excuses - as they still have many open items on my bug-list - but it may be an indication of a systemic problem with their forum review process, and not an intentional oblivion.

    Check the top-10 most commented on forum entries... 90% are still open for 2+ years, and most have not seen a moderator comment in many moons.

    · Share on FacebookShare on Twitter
  • R.McCallie
    R.McCallie ✭✭

    this seems to have fallen off their radar.

    I too would love to see this functionality.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories