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 Community Champion

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.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Table view - open in preferred filter
I am working in the new Table view and ask if there is a way to have the sheet open already in a filtered view? It would be even better if I could have multiple filters and set a preferred one. It is default in Grid view for the sheet to open with my last filter applied, so there must be a way to do the same in Table view.…
Can I set an automatic response to forms submission?
I have a form set up to capture submissions of great work accolades from team members. I want to set up an automatic response to fire upon submission of a form to suggest a different way to reward great work. I cannot seem to find this capability in any of the discussions.
Formatting Dashboard Metrics with Commas (,)
There are two places where I am unable to format the numbers with commas (,): first, the Sheet Summary; and second, the Dashboard metrics. It's very difficult for my dashboard visitors to interpret large numbers without commas (e.g., the amount 2320050 would be a lot easier to read as 2,320,050). Please not that the…

woman with hands out and open

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

Watch video<