Can I combine multiple rows into one row on a Gantt Chart?
Dear all,
I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows. Is there any method to combine multiple rows into one row and use one row to present one project on Smartsheet?
Best Answer
-
Andrée Starå ✭✭✭✭✭
Hi @Sam Ng
Unfortunately, it's not possible at the moment to combine rows, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could maybe use a 3rd party service/integration.
Is that an option?
I hope that helps!
Be safe and have a fantastic week!
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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
5
Answers
Hi @Sam Ng
Unfortunately, it's not possible at the moment to combine rows, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could maybe use a 3rd party service/integration.
Is that an option?
I hope that helps!
Be safe and have a fantastic week!
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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Hi @Andrée Starå
Thank you for your response. I have submitted an Enhancement Request.
Cheers,
Sam
@Sam Ng
Excellent!
Happ to help!
✅Remember! 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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
This is from the smartsheet template site: https://www.smartsheet.com/content/project-timeline-templates
How can we create this, multiple milestones represented on a single line?
Hi @John Chun
It’s not possible in Smartsheet, but it might be by using the 3rd party service, Office Timeline.
Would that work?
I hope that helps!
Be safe and have a fantastic week!
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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Andrée,
Thanks for the suggestion to look into Office Timeline.
It's a little misleading thaty Smartsheet would show this timeline as an example template when it is not available.
Thanks for the reply/suggestion.
Stay well!
-John
@John Chun
Happy to help!
Yes, maybe it could be made more clear that it's not in Smartsheet.
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
I find it astounding that this basic feature is not available. Have also submitted a feature request, but it appears this functionality has been requested for the past 4 years and still nothing.
@Andrée Starå the third party app you share is to generate timelines in powerpoint. How would you then suggest to integrate that timeline into a Smartsheet Dashboard?
Thanks
Tiffany
Hi @Tiffany Talsma
You can use the Web Content Widget to embed the Powerpoint.
More info.
Would that work/help?
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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Any update on the ability to do combine project milestones into one line on a master schedule without add on software?