Hello All,
I am building a file that allows someone to create a basic timeline using dropdown selections. These dropdowns in individual rows change the durations of their respective tasks. I would like to build a visual timeline bar that appends all of the rows data together into a single timeline visual on one row.
Example
Task A = 2 weeks
Task B = 3 weeks
Task C = N/A for this project
Task D = 2 weeks
The Timeline result I'd like to see is:
A A B B B D D
Where each letter is in a separate column on the same row allowing me to use conditional formatting to color code the tasks and show the consolidated duration of the tasks as a whole project.
Any help with this would be appreciated!
I am building a file that allows someone to create a basic timeline using dropdown selections. These dropdowns in individual rows change the durations of their respective tasks. I would like to build a visual timeline bar that appends all of the rows data together into a single timeline visual on one row.
Example
Task A = 2 weeks
Task B = 3 weeks
Task C = N/A for this project
Task D = 2 weeks
The Timeline result I'd like to see is:
A A B B B D D
Where each letter is in a separate column on the same row allowing me to use conditional formatting to color code the tasks and show the consolidated duration of the tasks as a whole project.
Any help with this would be appreciated!
