top of page

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([% 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 at

4,332 views0 comments


bottom of page