Active Member
January 29, 2021
Hi All
I made my Dashboard under Youtube instruction. It works ok but I want to add one more tweak that can change the view of the Gantt part in multiple timelines such as weeks, months as well as days. I succeeded in changing the view according to weeks and months, including column width, by selecting button form, but the graph part with embedded formulas doesn't show correctly. Could you give me advice so that I could show the graph part with proper the dynamic timeline?
Thank you for your help
HT
July 16, 2010
You can use the TEXT function to change the formatting of the dates returned by SEQUENCE to suit the periods selected in the Radio Buttons. You'll need an IF to detect which format to apply.
Converting the dates to their week ending and month equivalents should be easy, but here is a tutorial on converting dates to quarters.
I hope that points you in the right direction. Come back if you get stuck and share your attempt.
Mynda
Active Member
January 29, 2021
Dear Mynda
Thank you for the advice. Your recommendation would work for the timeline but do you think the modification would also work the graph part? Since many formulas composed the graph part, I guess the formulas also need to be change.
Thank you for your advice
Hiroto
1 Guest(s)