I recently realized that Smartsheet has a major flaw in rolling up % Completion.

In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows


Hey everyone,

I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day:

=IF(AND(Date9 = TODAY(), Difference9 < 0.05),