Count of Children Incorrect

Options
✭✭✭✭✭✭

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

• ✭✭✭✭✭✭
Options

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 "

• ✭✭✭✭✭✭
Options

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 "))
```

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

• ✭✭✭✭✭✭
Options

Here is my suggestion:

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

• ✭✭✭✭✭✭
Options

@Paul Newcome Received an Error: Unparseable

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options
• ✭✭✭✭✭✭
Options

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 "))

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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 "

• ✭✭✭✭✭✭
Options

@Paul Newcome That Worked, Thanks!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!