Is there a way to calculate percent complete in the summary page without parent/child relation?

Leann Gibson

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?

Kelly Moore

Leann

Create a text/number summary field.

Your formula is

=AVG([%Complete]:[%Complete]

Does this work for you

Kelly

Kelly Moore

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

Leann Gibson

Hello, I want to average the %Complete column

Kelly Moore

Leann

Create a text/number summary field.

Your formula is

=AVG([%Complete]:[%Complete]

Does this work for you

Kelly

Leann Gibson

Perfect, that worked. Thank you