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

Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…
A workflow has become invalid
Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated. The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and…
Permissions Workspace vs Sheet
I want to set a Workspace permission for all members (except Owner and 1 Admin) to Editor - Can Share, which I'm able to do. Within that workspace are some files that I want some of the members to have Admin permission, but still only have Editor permission for the other files in the Workspace. When I open the sheet for…

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