|
Google Sheets
| #59
[Workspace] Present a pretty timeline in Google Sheets
Workspace editions only apply for Google Workspace users (i.e. businesses), and are sent in addition to the regular weekly Productivity Pings
(you can now filter previous editions by application!)
š¤ What is it?
Google Sheets is taking a page out of Notionās book; you can now create a Timeline View from a table that includes āStartā and āEndā dates
Before
After
š”
Pro tip: You technically only need a āStart Dateā column to create a timeline but Iād recommend at least 4 columns: āStart Date,ā āEnd Date,ā āAction Details,ā and āStatusā
š¤·š» When should I use this?
If Iām a project owner, I wouldnāt want to present the āAction Itemsā table (see āBeforeā image above) to my manager or stakeholders since itās so wordy
Therefore, I personally use the Timeline View to generate a easy-to-digest visual representation of how the project is going so far
š”
Pro tip: Use data validation + conditional formatting to add color to your timeline cards (for me,I always use WIP = Yellow, Done = Green)
Instructions to generate Timeline view
āØļø Keyboard shortcut
- Press CMD+A twice to quickly select all cells within a Google Sheets tab (CTRL+A for Windows users)
Follow up questions? Click āView Onlineā and you can comment on this post directly! Or give anonymous feedback here š
Want someone to be more productive? Let them subscribe here š
Thanks for being a subscriber, and have a great day!