Count Children Criteria Out of Totals

Kaleb

Smartsheet Community:

I am Trying Create a Formula That Will Count The Total Number of Children That Pass Out of the Entire Population Set. For Example:

10 Out of 300 Test Cases Passed

My Formula:

=COUNTIF(CHILDREN()), "Pass" + " Passed Out Of " + (COUNT(CHILDREN(), " ") + " Pass")

Thanks

Kelly Moore

I believe @Michael Culley is suggesting

=VALUE(COUNTIF(CHILDREN([Test Status]@row), "Pass")) + " Passed Out Of " + VALUE(COUNTIFS(CHILDREN([Test Status]@row), OR(@cell = "", @cell <> "")))

The formula uses the VALUE function because you are mixing text and numbers together. Smartsheet doesn't know whether to treat the COUNTIFS function as text or number. Without the VALUE function the formula would throw an error (try it). The VALUE forces the function to behave as a number.

Kelly

Michael Culley

You need to select a cell inside of your children parenthesis. So basically Children(parentrow@row) something to that effect.

Kaleb

https://community.smartsheet.com/discussion/comment/339926#Comment_339926

I am Not Sure I Follow. I am Counting All the Children as a Total but want to Count the Number of Pass. i.e. 4 Out 300 Passed.

Are you Saying Something Like This? If So, it is UNPARSEABLE:

=COUNTIF(CHILDREN([Test Status]@row)), "Pass" + " Passed Out Of " + (COUNT(CHILDREN([Test Status]@row), " ") + " Pass")

Kelly Moore

I believe @Michael Culley is suggesting

=VALUE(COUNTIF(CHILDREN([Test Status]@row), "Pass")) + " Passed Out Of " + VALUE(COUNTIFS(CHILDREN([Test Status]@row), OR(@cell = "", @cell <> "")))

The formula uses the VALUE function because you are mixing text and numbers together. Smartsheet doesn't know whether to treat the COUNTIFS function as text or number. Without the VALUE function the formula would throw an error (try it). The VALUE forces the function to behave as a number.

Kelly

Kaleb

https://community.smartsheet.com/discussion/comment/339941#Comment_339941

Than Worked, Thanks!