Report Builder: Include Only Top Level Gantt Chart Rows

Hello,

I'd like to design a report of overdue projects in my Gantt chart. I can easily design a report showing all incomplete, over due tasks. But what if I only want the top level items on the report ... those that are not indented?

Using this forum, I read an answer to another question that prompted me to add a new column called "Top Level", in which I put an "x". So, how do I specify that the report should only output rows with "x" in "Top Level"?

I tried sorting, but that's not limited the report to Top Level records, only sorting all tasks.

Here's what's in the Report Builder:

Where: My sheet
Who: Blank
What: % Complete is < 1
When: Finish is in the future.

Thanks all.

Jon

Find more posts tagged with

Reports

Comments

Angie Hatfield

Here's what I would try. I would put a column in named as you want and then put an X in the applicable row. Then add it as a What in the report builder. It will then only includes those with the X in the row in your results. Or where the field is not blank. That would be the simplest thing I think I would try.

You don't have to include the column in your results, just to get the data.

Nic Larsen

You should only need to add another level to your report under the What? column. Select What? again and add your new column and that you want to see those that are checked.

Jon's Smartsheet

Perfect! That did it. But what I was having trouble with was how to add a 2nd "What".

Now I see that Step 1 is to click "What", then Step 2 allows you to select multiple fields for multiple criteria.

Thanks.

Sign in to join the conversation!

Quick Links

Trending discussions

I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…