Working with % Complete in Smartsheet

#Smartsheet #ProjectManagement #RemoteWork

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

1,777 views0 comments