Automating a Gantt chart from Jira Kanban in early planning
The execs want a Gantt chart from my Kanban board. I will be using the Jira/SmartSheet connector for this task. Here is my current thinking:
- Take the total number of tasks and divide by the available work time to create an average size if the tasks completely fill the time (the SME who will be sizing the items has not been hired yet).
- Plot these end-to-end over the timeline of the Gantt chart.
- Separate tasks by Department (this field has been utilized in Jira) such that each department's first task starts at the same time (project start date)
Is there any way to automate this so I do not have to manually set start and end dates for 361 tasks? Has anyone used another method of providing a Smartsheet Gantt chart from a Jira Kanban board without compromising the Kanban in Jira?