Quantity AND % Complete for children rows

I'm trying to make the parent row say the qty of children AND the % in the "Complete" column that will auto adjust once checkboxes are clicked. Note, each parent row will have different quantities of children.

Right now I am using the below formula and I don't like that it gives so many decimals:

=COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%"

example: "(0/7) 0%"

Any advise is much appreciated.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

The protion that outputs the number would be wrapped in the ROUND function like so:

=ROUND(COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100) + "%"

All comments

Paul Newcome

You can wrap the portion that outputs the number in a ROUND function and specify how many decimals to show before the "%" is appended.

TaylorBrown123

thanks for the response @Paul Newcome would you mind helping me out with the full formula for this? i would prefer to round to the nearest whole number, eliminating all decimals if there is no way to count them and display the percent in the same cell.

Paul Newcome

The protion that outputs the number would be wrapped in the ROUND function like so:

=ROUND(COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100) + "%"

TaylorBrown123

That will work for what I am doing. Thank you so much for your help! @Paul Newcome

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.