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.

One tab, multiple reports?

Jacob Tolman
edited 12/09/19 in Archived 2015 Posts

Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple reports on one tab?

Comments

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    I would suggest you use cell linking from each of your sheets to create a Portfolio view that shows the Key Performance Indicators of that sheet in a single row. From that sheet you can jump straight into the source sheet from a double click. 

    OR you could use a report to pull in the main (KPI) rows from all the Sheets so you have a similar Global View, then if you wish to interrgate the source sheet just double click the live link. 

    I am not aware of any way to stack reports on top of each other in one tab as requested but the above should get you what you seek? 

    Hope that helps.RichardR

  • Jacob Tolman
    edited 10/23/15

    Thanks, Richard. I started to do what you first recommended (linking my sheets one cell at a time), but that got to be very manual seeing as I could not drag the cells and have the formulas/linkes follow along. 

    Pulling in the aggregated KPIs might work... I'll try that out. My initial concern is that the formulas available to me are limited (compared to Excel). I'll play around with it and see what I can come up with. 

     

This discussion has been closed.