Clicking into Data in pivots


Hi all, does Smartsheet have the capability of clicking into data in pivots. For example in the image below if I were like to view the 35 items in column two. In excel I can just click the 35 and then it would populate a sheet with all of them. Does Smartsheet have that capability?



  • Matt___New_Era_Tech

    Hi @JDSpec13

    While Smartsheet Pivot does not support this functionality out of the box, it is fairly easy to replicate using a report or a series of reports that look at the source data. You will want to look into group/summary functionality in Reports to make it look nice.

    Happy to answer any further questions!

    Matthew Strehler | Senior Solutions Consultant

    New Era Technology |