Count of Children Incorrect

Smartsheet Community:

My Formula Is the Incorrect total number of Children. I am sure it is a Minor Tweak but I cannot seem to find where I need to correct my formula.

Current Formula:

="Site Execution: " + COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + " of " + ((COUNTIF(CHILDREN([% Complete (Actual)]@row), 1) + (COUNTIF(CHILDREN([% Complete (Actual)]@row), 0)) + " Completed "))

Results 21 Of 48 Completed

However the Total Number of Children is 52. Therefore, it should be 21 Of 48 Completed.

Thanks

Find more posts tagged with

Accepted answers

Paul Newcome

My apologies. I missed that the two parenthesis at the end should have been removed from the original formula in addition to my other changes.

="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "

All comments

Bassam Khalil

Hi @Anthony Barthelemy

Hope you are fine, please try the following formula :

="Site Execution: " + COUNTIF(CHILDREN([% Complete (Actual)]:[% Complete (Actual)]),@cell=1)) +
" of " + COUNT(CHILDREN([% Complete (Actual)]:[% Complete (Actual)])) + " Completed "))

Anthony Barthelemy

Received an Error: Unparseable

Paul Newcome

Here is my suggestion:

="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "))

Anthony Barthelemy

@Paul Newcome Received an Error: Unparseable

Paul Newcome

Are you able to provide a screenshot of the formula in the sheet similar to the screenshot below?

Anthony Barthelemy

Paul Newcome

What about the formula I previously provided?

="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "))

Anthony Barthelemy

When I copy and Paste it is Unparseable. Screen Shot Below

Paul Newcome

My apologies. I missed that the two parenthesis at the end should have been removed from the original formula in addition to my other changes.

="Site Execution: " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), 1) + " of " + COUNTIFS(CHILDREN([% Complete (Actual)]@row), OR(@cell = "", @cell <> "")) + " Completed "

Anthony Barthelemy

@Paul Newcome That Worked, Thanks!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.