Calculating Project Level Percent Complete in Smartsheet | Smartsheet Tutorial

In this video, Dan from School of Sheets shows you different ways to determine the percent complete of your Projects at the project level using hierarchy, formulas, and sheet summary fields. 💻 FUNCTIONS USED ➣ =AVG(CHILDREN()) ➣ =AVG([% Complete]:[% Complete]) ➣ As a bonus, MIN() and MAX() are used to pull in the earliest start date and latest end date for the project via =MIN(CHILDREN()) and =MAX(CHILDREN()) 🏢 ABOUT SCHOOL OF SHEETS ➔ We are a bespoke consulting firm specializing in developing custom Smartsheet Solutions ➔ We are a Smartsheet Aligned Gold partner with a team of certified consultants and software developers. ➔ We work with businesses of all sizes and industries. ➔ Learn more at http://www.schoolofsheets.com 🤝 WANT TO WORK WITH US? Fill out our new client interest form at https://www.schoolofsheets.com/WorkWi... 📚 KEY RESOURCES ➔ Try Smartsheet free for 30-days http://www.schoolofsheets.com/TrySmar... 🔔 SUBSCRIBE FOR MORE GREAT CONTENT 👉    / @schoolofsheets   ⌚ TIMESTAMPS 00:00 – Intro 00:20 – Example Sheet and Data 00:58 – Using Hierarchy 04:27 – Using Smartsheet Project Settings 07:10 – Using Sheet Summary Fields without Hierarchy 08:45 – Summary 09:20 – Outro #smartsheet #formula #automation #projectmanagement