Google Sheets can be a handy tool for project management. I wanted to create this post to share a few tricks to build a Gantt chart in Sheets.
Note...
For further actions, you may consider blocking this person and/or reporting abuse
Why would you want to do this?
I have never seen Gantt charts work, but that might also be due to the various PMs I had to deal with. But spreadsheets abuse is already a major thorn in my eye.
"Your scientists were so preoccupied with whether they could, they didn't stop to think if they should." -- Dr Ian Malcolm
Gantts can be lovely, not so perfectly suited for perhaps day-by-day planning (as things can move too quickly), but for a general snapshot of a plan, especially for initial kickoffs and for presentations to a client or team. And this is a lot more legible and visually clean than a deeply detailed gantt such as gantter, smartsheet, or good ol' ms project.
I think they can be very useful to visually where task A ends and task B picks up. This is especially useful for visualizing which tasks can be tackled in parallel and which ones cannot. For large projects this is a great tool to refine a time estimate.
Use dates in ISO 8601 format see w3.org/TR/NOTE-datetime and those from the U.S. and anywhere else will understand.