Add Summary Value from Sub Tasks
Hi all,
I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible?
Thanks in advance!
Tags:
Answers
-
Use this...
=AVG(CHILDREN())
-
i have treid this formular and i get no joy it will not let me type a -formular into the cell
-
@Brian Rich Can you provide screenshots?
-
I have the a similar problem to @Brian Rich. The summary will only change to 100% if all sub tasks are 100%. Otherwise it is 0% no matter what.
Nevermind. I forgot that i had to put in a start and end date. Works now
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!