How to Build a Project Management Template in Google Sheets (Project Milestone Tracker) and Excel
Автор: Hustlesheets
Загружено: 2022-10-02
Просмотров: 14122
Purchase template here: https://hustlesheets.samcart.com/prod...
Book a consultation call here: https://clarity.fm/hustlesheets
Automatically connect marketing data such as FB Ads to Google Sheets here: https://supermetrics.com/?idev_id=2372
Watch and learn how to build this project management tracker (easily track project milestones) in Google Sheets. I am using a solar sales business as my example. This is similar to a Gantt chart.
Chapters:
0:00 Intro
2:39 Step 1: Determine your project steps
4:58 Step 2: Set # of days between each step
7:44 Step 3: Create basic columns
10:08 Step 4: Dropdowns
15:25 Step 5: Status logic mapping
21:56 Step 6: Write first status formula
39:09 Step 7: Status formula for other steps
49:17 Step 8: Conditional formatting
57:18 Step 9: Formatting / Scorecards
1:00:30 Bonus: Notes tips
1:02:28 Bonus: How to sort
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
