parent child filters in reports

sallison

sallison ✭✭✭

02/21/23 in Smartsheet Basics

I would like to create a report that pulls in all children rows beneath a parent row that has a key word. Is that possible?

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

02/21/23

You would need a helper column that brings the particular key word (through a formula) from the parent row into each of the child rows.

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

MS Project Import Question
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
Card View: Can't sort by desired category
I would like to use card view for one of my sheets - and sort it by the "type of service" that was performed on our equipment. For some reason, I am able to sort my cards by literally every category but that one. The column is a drop down menu. Is that the reason I am unable to sort by that category? Not sure why I…
Summary Function Between Business and Pro
Apologies if this is the wrong area to post this… I am a one-person shop that uses Smartsheet to manage various tasks. One of these is the PTA where I volunteer as a board member. I would love to use the dashboard feature to track certain metrics (parent attendance at events and our performance in fundraising) and show…

Help shape the future of Smartsheet.
Share your ideas and feature requests.