top of page
Search

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 at http://bit.ly/Try_Smartsheet_Free



4,332 views0 comments

Kommentare


bottom of page