Showing the Parent Row in a Report

Helen Percy

Hello Community,

I have created a report where I am only showing if there is information to show, however my Parent Row (which in this case indicated which week the information comes from), isn't being shown. Any ideas on how I can have the Parent Row from the Source Sheet show up in my report?

Report Snip - not showing Parent Row.JPG

Source Sheet Snip - showing Parent Row (in black).JPG

Erin Greunke

Hi @Helen Percy !

A few other users have posted this same inquiry and suggestions were given -- have you had a chance to search through the Smartsheet Community yet?

Here are a few of the forums -- let me know if these don't address your issue:

1. Show both parent and child rows in report, even if the Parent doesn't meet the criteria
2. Parent Row in Report (#1)
3. Parent row in report (#2)

I personally have used "Helper Columns"... Like a checkbox column, where if the box is checked, I'd like the row included on a report, and I set that as a filter criteria in the report.

Erin Greunke

Hi @Helen Percy !

A few other users have posted this same inquiry and suggestions were given -- have you had a chance to search through the Smartsheet Community yet?

Here are a few of the forums -- let me know if these don't address your issue:

1. Show both parent and child rows in report, even if the Parent doesn't meet the criteria
2. Parent Row in Report (#1)
3. Parent row in report (#2)

I personally have used "Helper Columns"... Like a checkbox column, where if the box is checked, I'd like the row included on a report, and I set that as a filter criteria in the report.

Helen Percy

Hello @Erin Greunke

Thank you for your reply and the links, as I had trouble searching for my issue and they have helped a great deal.

I shall use a helper column for now until this function has been implemented in an enhancement.

Many thanks for your time and help.

Kindest regards,

Helen

dizzy_brain

I have the opposite question. How to NOT show parent row in a row report? I am learning this, so keeping very simple. I have a sheet called Meetings, where I name the meeting with my staff (parent row e.g. Meeting (Davide/Eugene) and nested under are various tasks that each has to do. I created a row report, in which I only want the tasks to appear (without the parent row) but I don't know how to have parent row not show up? Thank you

Genevieve P.

Hi @dizzy_brain

Will your Parent rows always have a blank "Assigned To" or blank "Project" cell? If so, the simplest way to do this (without added columns or formulas) would be to add a Filter statement that excludes rows with a blank Project cell and a blank Assigned To cell.

Let me know if that will work for you or not!

Cheers,

Genevieve