How do I get a Gantt chart into a report

Alan Meshaw

From SS Engage:

'https://www.youtube.com/watch?v=ZTcfzjq0GEE&feature=emb_rel_end

jump to minute 34:38 of that video

for example of how they embedded the chart, but they never said how they built the report

I have one sheet referenced, I want the items of the primary column that align with

initials of Column 8 to be displayed with start date and end date (columns 9

and 36 respectively)

I have seen all of the tutorials about what reports can do, none have shown how to get that Gantt chart in there

Andrée Starå

Hi @Alan Meshaw

You’ll need to add Conditional Formatting rules in the sheet(s) for the format to be automatically applied to the Task bar.

https://help.smartsheet.com/articles/516359-conditional-formatting

For rows that meet the condition, apply a color to the card border in Card View or the Gantt and Calendar bars in Gantt View or Calendar View. A color will be applied to a card, Gantt bar, or calendar bar only if you've applied the rule to the entire row.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

@Alan Meshaw

You're more than welcome!

The Progress Bars are based on the % Complete value. You need to activate the Dependencies feature for it to work.

Make sense?

Ramzi K

Alan Meshaw

Please look at the screen shot at 34 minutes (link in OP) that shows a report with Gantt chart embedded in a dashboard. I now have the chart in there, but cannot get the color coding to align as the presenter did with "Objectives of Executive Team", or show the percent in progress (I have a singular block, but want the progress bar--so I will keep working on it). The original post is not about just seeing Gantt view, but the portion within the report in a dashboard. That is the magic I am trying to duplicate, but thanks for responding.

Andrée Starå

Hi @Alan Meshaw

You’ll need to add Conditional Formatting rules in the sheet(s) for the format to be automatically applied to the Task bar.

https://help.smartsheet.com/articles/516359-conditional-formatting

For rows that meet the condition, apply a color to the card border in Card View or the Gantt and Calendar bars in Gantt View or Calendar View. A color will be applied to a card, Gantt bar, or calendar bar only if you've applied the rule to the entire row.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Alan Meshaw

Thanks, I have incorporated that now. Any idea how they made the columns in that Report embedded Gantt view to create the progress bars?

Andrée Starå

@Alan Meshaw

You're more than welcome!

The Progress Bars are based on the % Complete value. You need to activate the Dependencies feature for it to work.

Make sense?