How do I get a Gantt chart into a report
![Alan Meshaw](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
Best Answers
-
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.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
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.
-
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.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks, I have incorporated that now. Any idea how they made the columns in that Report embedded Gantt view to create the progress bars?
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives