Is there a way to calculate percent complete in the summary page without parent/child relation?
I have a action tracker for my department. All information in as via a form. I want to use the Summary Sheet to show overall % complete of all tasks based on the % Complete column. Is there a way to do this in the summary sheet without having to create the parent child relation?
Best Answer
-
Leann
Create a text/number summary field.
Your formula is
=AVG([%Complete]:[%Complete]
Does this work for you
Kelly
Answers
-
Hey @Leann Gibson
Are you wanting to average your %Complete column? Or is it a count of only your 100% complete over the total count? Neither of these approaches require insertion of a Parent row
Please advise on what type of calculation you need and I'll be happy to help
Kelly
-
Hello, I want to average the %Complete column
-
Leann
Create a text/number summary field.
Your formula is
=AVG([%Complete]:[%Complete]
Does this work for you
Kelly
-
Perfect, that worked. Thank you
Help Article Resources
Categories
Check out the Formula Handbook template!