=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!

Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @AmandaC

    Will there be any defining detail on these additional rules that will allow you to exclude them from the total count?

    For example, if these additional rows all say "Test" in a certain cell, you could use a COUNTIF instead of a COUNT as the second half of your formula:

    =COUNTIF(CHILDREN(), 1) + " of " + COUNTIF(CHILDREN([Specific Column]@row), <> "Test")

    Let me know if that makes sense! I'd be happy to help further but it would be useful to know more about these addition rows and why you want to exclude them.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!