Need help creating formula to show # of Children that are complete & percentage

Sfogg123_iodine

Should display something like: 2/10 (20%)

# completed tasks / total tasks (percentage of total)

Can you please help?

Leibel S

Something like this should work:

=COUNTIF(CHILDREN(Complete@row), @cell = 1) + "/" + COUNT(CHILDREN()) + " (" + IFERROR(ROUND(SUM(COUNTIF(CHILDREN(Complete@row), @cell = 1) / COUNT(CHILDREN())) * 100, 0), "0") + "%)"

Leibel S

Something like this should work:

=COUNTIF(CHILDREN(Complete@row), @cell = 1) + "/" + COUNT(CHILDREN()) + " (" + IFERROR(ROUND(SUM(COUNTIF(CHILDREN(Complete@row), @cell = 1) / COUNT(CHILDREN())) * 100, 0), "0") + "%)"

Sfogg123_iodine

Thank you @Leibel S . This resolved it!