Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
The existing percent complete formula takes into account the duration when providing a roll-up calculation for parent tasks. This calculation is inaccurate and should not include the duration in the formula but rather calculate the Average roll-up for all child tasks. The formula should be as follows
=AVG(CHILDREN())
Sign in to comment or add your vote.