Count of Children Incorrect

Anthony Barthelemy

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

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 "

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. 👍️