Date Grouping for Gantt Dashboard
I'm trying to automate a sheet into a Gantt Dashboard, however I am having issues finding a work around to show the child and parent dates, as all the information is stored in one row, rather than 3 rows for example.
Sample Column Names: Project Name, Task 1 Start Date, Task 1 End Date, Task 2 Start Date, Task 2 End Date, Project Start, Project End
So I need some way to group the dates under 3 rows, for example Project Name, Project Name Task 1, Project Name Task 2.
Is there a work-around this? I have not been able to find anything so far.
Help Article Resources
Check out the Formula Handbook template!