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.

reporting hierarchies

This may have been already answered, but is it possible to setup a report to display all the child rows of a hierarchy when a parent row is selected?  I have different information on several sheets with a couple common reporting columns, but I still run into the problem of report criteria either being too narrow or too broad; if I could setup the report to display all the child rows of the selected parents (which have a common identifer across all the sheets), I could print a summary report of one project (or one type of project), including all conversations and projects/tasks in process associated with that project, which would be EXTREMELY useful. 

 

I'm hoping there's some simple trick to this that I am missing as a newbie.  Laughing

 

Elliot

Tags:
«1

Comments

  • Zack S
    Zack S Employee

    Hello Elliot, 

     

    At this time we don't have a way to include hierarchies in reporting so that if a parent row is pulled all child rows are pulled as well, but I'll add your vote for this capability to our enhancement request list for our Product team to review. 

     

    -Zack 

  • Please add my vote too. It makes the use of reporting not very helpful when sharing a project plan with executives. I exported to Excel where hierarchies are shown. However printing is unusual.
  • Travis
    Travis Employee

    I have added your vote, Colleen! 

  • Update; I've been poking around my sheets, with the help of your tech support (plug to Luka here), and between my searching and his suggestions, I have a workaround that does pretty well.

     

    I setup a checkbox column, and each cell in the column containts the following formula: "=IF(Priority2 = "0 New Lead", 1, 0)".  'Priority 2' is one of the categories in a separate dropdown column, depending on the the prospect's level of interest (this is basically a sales pipeline tracking system).  On the report side, I have the report built on 'priority is 'X'', and 'Report check is checked', to get only the rows with updates for each priority level on a single report.  I still have to update each prospect manually, but I set up a separate standing report for each priority level, which automatically updates when I save the changes (sorry if this is a little basic).

     

    I also created duplicate columns from my other sheets (meeting follow-ups and sales pipeline by stage), and put them in one master sheet.  Since I can create specific reports for each set of parameters I want, there's no reason not to have everything on one data sheet, as I've filtered out or hidden all the extraneous data on each report.

     

    Again; apologies if some of this is a bit basic; it took me a long while to get here, and I wanted to walk through the process so that someone else doesn't have to slog through it like I did.  Money Mouth

  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Great input, thanks Elliot! 

  • Dawn Morgan
    Dawn Morgan ✭✭✭

    Please add my vote too.  We have users here at the bank who want to roll reports up to provide to the Exec Team and want to display both the "parent" & "child" rows/data in a collapsable format.  Currently it displays but just shows in cells that kind of seem out there by themselves.

  • Travis
    Travis Employee

    Hi Dawn - I submitted your vote for this!

  • Alisa Collins
    edited 01/13/16

    Add my vote as well. Thx.

     

  • Add mine as well.  I'm working on a report across 6 teams, with over 2000 rows, over 70 collaborators and now I have to go in and paste data (repeating) into every column someone wants to filter on or it won't show up.  

  • Travis
    Travis Employee

    Alisa and CDE - your votes have been added!

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    Please add mine.  If reporting is just a filter of the sheet, then it should be able to keep the heiarchy more simply than me adding a formula in all of my sheets.

    I'm in the same boat as CDE> Not as many users, but when it is more complex solution, I am not able to develop users who can master the solution themselves.

     

    Great job security but hard to sell to senior management.

     

    Tim

  • Has any progress been made on retaining hierarchy of parent and collapsable child rows in reports? I also have the need to share reports with exec and I want to be able to hide the minutia from their simple, high-level view. In the meantime, how can I create a report showing only the parent rows? (And ... thanks for your input guys!;)

  • Hi Alicia,

     

    Though this isn't on our Product Roadmap currently, we are tracking input from our customers on this, and I've added your vote for it to our enhancement request list! 

  • Dawn Gagnon
    edited 06/21/16

    my vote as well please. I have about 15 sheets in 15 different workspaces I need to roll up into one report

This discussion has been closed.