No video

Mastering Gantt Charts in Google Sheets to Visualize Project Timelines

  Рет қаралды 2,703

Sheets Ninja

Sheets Ninja

Күн бұрын

A Gantt chart is a way of visualizing project timelines. In this video, I show you how to create a simple gantt chart for your project in less than 5 minutes. In the rest of the video, I walk you through making it look really professional.
If you want to make a copy of the final Google Sheet from this project, you can do so at the following link: bit.ly/3QN2UaU
Here's the link to my tutorial on conditional formatting for more on that: • Conditionally Format R...

Пікірлер: 4
@taitaasersiron4375
@taitaasersiron4375 20 күн бұрын
Thank you and really like your contents they clear and clean :) but could you go through that ends of your videos make a quick example of how to use these sheets in the proper way just for novice so they could get a better understanding of the afterwards .. cheers 😊
@Drag0nStorm1
@Drag0nStorm1 3 ай бұрын
how... how are you pushing the month cells when you change the value? What I mean is Let's say feb has 28 days and you have 28 columns between the FEB and MAR columns when you change the value in the FEB cell from 2/1/23 to 3/1/23 it changes to MAR, sure, BUT WHAT IS ADDING COLUMNS TO COMPENSATE FOR THE ADDED DATES IN BETWEEN? in my experience, the merged cell and the colour and formatting of it, would all generally stay in the same cell REFERENCE, and so the date of the new MARCH 29th would pop into the MAR cell wouldn't it?? breaking everything? Is the key in collapsible grouping?
@Drag0nStorm1
@Drag0nStorm1 3 ай бұрын
oh NVM i missed that you left blank columns so all are equally 31 days long hmhmmhmmm sorry i spoke too soon xD
@SheetsNinja
@SheetsNinja 3 ай бұрын
Yeah, you can either leave extra blank columns if you want to be able to have any month fit into any slot, otherwise for some people they prefer to keep it tied to a calendar year in which case February would need 29 days for leap year but otherwise you could remove the extra day columns.
How to Create an Awesome Gantt Chart in Google Sheets
22:46
Spreadsheet Life
Рет қаралды 7 М.
这三姐弟太会藏了!#小丑#天使#路飞#家庭#搞笑
00:24
家庭搞笑日记
Рет қаралды 10 МЛН
My Cheetos🍕PIZZA #cooking #shorts
00:43
BANKII
Рет қаралды 27 МЛН
Pool Bed Prank By My Grandpa 😂 #funny
00:47
SKITS
Рет қаралды 20 МЛН
Interactive dashboards in Google sheets
17:42
David Benaim
Рет қаралды 74 М.
How to build a Timeline Gantt Chart in Google Sheets
8:58
Spreadsheet Wise
Рет қаралды 21 М.
Google Apps Script for Beginners: Start Automating Google Sheets
8:03
Analytics with Adam
Рет қаралды 18 М.
I Built a FREE Sales CRM with Google Sheets (2024)
13:56
CloseDr
Рет қаралды 1 М.
How to Create a Gantt Chart in Google Sheets
10:41
Vertex42
Рет қаралды 911 М.
✨ Google Sheets Introduces Tables
7:27
Dan Leeman
Рет қаралды 29 М.
Creating a Gantt Chart in Google Sheets
21:11
Ilya Mikhelson
Рет қаралды 471 М.
COMPLETE CRUD WEB APPLICATION USING GOOGLE SHEETS #googlesheets
17:41
Automate Google Sheets with Chat GPT Macros & Apps Script
15:24
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 70 М.
Make This Awesome Gantt Chart in Excel (for Project Management)
17:13
Kenji Explains
Рет қаралды 267 М.