Working with % Complete in Smartsheet

In this video, I’ll show you different ways to determine the percent complete at the project level.

Determine the percent complete of an entire column using hierarchy, formulas, and sheet summary fields.

Example formulas 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())

Try Smartsheet for 30 days free HERE.

Unlock the Full Potential of Smartsheet

Focus on growing your business while our Smartsheet experts handle the rest. Book Your Discovery Call today!

Strategic Plan Dashboard Image.