
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)
