Google Sheets: Create Timeline (Gantt Charts) (in some Workspace Accounts only)

Поділитися
Вставка
  • Опубліковано 3 гру 2024

КОМЕНТАРІ • 31

  • @xaquison
    @xaquison Рік тому +3

    That was a great and easy to follow video. The timeline feature is still basic but hopefully Google will continue to improve.

  • @lizzycbr6700
    @lizzycbr6700 Рік тому +1

    Thank you this is exactly what I needed!!

  • @SashaMirpour
    @SashaMirpour Рік тому +1

    Really nice demo and walkthrough thanks!

  • @sarawootthongchan
    @sarawootthongchan Рік тому +1

    you make my day, thanks

  • @RockyN
    @RockyN Рік тому +3

    It appears that this feature is only available in the paid version, not free google docs.

  • @leonidas1983
    @leonidas1983 Рік тому +1

    Great work! Thanks

  • @hiroyukinumaguchi1984
    @hiroyukinumaguchi1984 9 місяців тому +1

    Great!

  • @AtirahHani
    @AtirahHani Рік тому +1

    Tq so much

  • @HaoNguyen-xr2nt
    @HaoNguyen-xr2nt 9 місяців тому

    Hi thank you so much for your video, it's really helpful. One question: Can we the Timeline combine the information of 2 tabs or more? thanks

    • @DoITTrainingSBU
      @DoITTrainingSBU  9 місяців тому +1

      not as is, but if you bring the data together on one sheet, you can create the timeline from that composite

  • @alanbrigham
    @alanbrigham Рік тому

    What type of account should I have?

  • @raphael9339
    @raphael9339 Рік тому +1

    Thanks it looks interesting and I want to try it. Possible to add milestones?

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +2

      Not specifically, but you could add them as rows in the spreadsheet with start date = end date

  • @dankirkland2863
    @dankirkland2863 Рік тому +1

    Is there a way to create dependencies so that a task only starts if all its dependencies have been met

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +2

      Not automatically, but you could use formulas to set start dates based on another task's start date and duration

  • @franciscoenzenhofer9754
    @franciscoenzenhofer9754 Рік тому +1

    Could it be exported as a pdf or an image?

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +1

      Not currently. Timelines can be downloaded (click File and then select Download) as .xlsx, .ods, .html, .csv, .tsv file

  • @saeedekhosravi3112
    @saeedekhosravi3112 9 місяців тому

    I can't find timeline tabe on google sheet . could you pls guide me?

    • @DoITTrainingSBU
      @DoITTrainingSBU  9 місяців тому +1

      Your Google Account likely doesn't have this feature - it's currently only in some Workspace Accounts: support.google.com/docs/answer/12935277?hl=en#zippy=%2Cthese-workspace-editions-can-use-timeline-view

  • @Gledii
    @Gledii Рік тому +1

    the timeline isnt availible on my Sheets :(

  • @patil88ganesh
    @patil88ganesh Рік тому +1

    Can we save the gant chart view?

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +1

      This was recently added - while viewing the timeline, File > Download and choose a format: .xlsx, .ods, .pdf, .html, .csv, .tsv

    • @patil88ganesh
      @patil88ganesh Рік тому +1

      @@DoITTrainingSBU Thank you, I think I did not frame my question right.
      I wanted to ask if the timeline view persists in that new sheet and next time when we open it or share that Sheet with someone, can we see the timeline view?

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +1

      Yes, it stays.
      I did find timelines I created months ago when timelines was first released got a bit buggy, but that might have been because timelines were new then? They should remain and are visible to anyone with view access to the spreadsheet

    • @patil88ganesh
      @patil88ganesh Рік тому +1

      @@DoITTrainingSBU Great, thank you!

  • @Leeeeman1
    @Leeeeman1 Рік тому +1

    Cannot find the Timeline Feature in my version of Google Sheets.

    • @DoITTrainingSBU
      @DoITTrainingSBU  Рік тому +1

      not all accounts have it (@gmail.com accounts don't have it, for example)