Report Builder: Gannt Chart Predecessors Not Working

I'm trying to run a single report of my 5 project schedules so I can quickly see aligning milestones and deliverables. However, when I run the report, all of the predecessors become unconnected and the columns report 1 predecessor. This is kind of a big deal for my reporting.

Anybody have a fix for this?

Thank you!

Find more posts tagged with

Reports

Gantt View

Comments

J. Craig Williams

This is definitely not normal behavior.

Can you post a screen shot or two?

Craig

ARCHIPEEP

Thank you for responding. See attached. Any help is appreciated!

Screen Shot 2018-03-12 at 5.06.46 PM.png

J. Craig Williams

Was this working before?

I was mistaken. I can't find an example where I was displaying the Predecessor column in a Report and I must have not cared about the 'missing' lines in the Gantt view (I'm not a big fan of Gantt)

That said, it makes sense to me why we are setting what we are seeing in the Report.

1. There is no guarantee that both a successor and predecessor meeting the criteria for a given Report. For example, if you are looking at non-completed tasks, the predecessor might be complete, but the successor isn't. There is no link to display.

2. The Predecessor row numbers don't mean anything in the Report. In a Sheet, if I reorder the rows, the Predecessor's number will shift to reflect the new row numbers that represent the connection. In a Report, this is not the case. Row 8 in your image is not row 8 in the underlying Sheet. It might be, but likely isn't. Let's assume it is 112. Does that information provide any value to the user of the Report? Very little and certainly nothing that is actionable. Instead "1 Predecessor", "2 Predecessors", "3 Predecessors", etc... at least gives us something semi-useful to work with.

If you had seen this working as you expect before, I would suggest contacting Smartsheet support (support@smartsheet.com) and maybe something has changed.

Sorry for the bad news.

Craig

ARCHIPEEP

Thanks Craig.

No, I hadn't gotten it to work, but I DID import the linked items. I would have just thought they would have been connected. I get your explaination for why, but I thought these were smart sheets

Gonna reach out to support. Thanks again.

Greg

Ami Veltrie

Hi Greg!

Curious...what ever came of this?

I'm having the same issue.

ddavis94596

I have the same issue...it continues unfixed.

Andrée Starå

Hi,

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

chris.stetler83201

I just ran into this myself. Any word on how we can pull the predecessor row numbers into the report? In my case, all predecessor rows will be displaying on the report

Brent Allen

Anyone had an update on this? Or figured a workaround?

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…