Sum Children and not show "0"

Rascal
Rascal ✭✭
edited 05/31/23 in Formulas and Functions

I am using =COUNT(CHILDREN()), but do not want the zero to show if sum is "0". Any suggestions on how to accomplish this? I tried adding IFERROR, but no luck.


Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Rascal

    IF(COUNT(CHILDREN())>0,COUNT(CHILDREN()))

    Will this work for you?

    Kelly

  • Rascal
    Rascal ✭✭
    edited 05/31/23

    @Kelly Moore

    THANK YOU!!!! I really do try to figure formulas out before asking for hep. Yes, it did work and can you assist with one more question?

    I now want to Sum or Count all the values in the column, which of course may have a value in the child roll, summed up in to the parent row. I have approached with a variety of formulas with no success.

    Any suggestions?

    Thanks again!

  • Rascal
    Rascal ✭✭

    @Kelly Moore

    I actually figured a formula out that will work....!! Can't believe I made it so difficult.

    SUM(CHILDREN([Week21 5/22-5/28]3:[Week21 5/22-5/28]141)) - will display sum of children. If there is a "cleaner" formula I am happy to use.

    THANKS!!

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Rascal

    Sorry for the delay in response- I've been leading trainings all week and haven't had a minute. I'm delighted you figured it out yourself! Great job! I hope you did a happy dance at your desk- that's what I do when I finally beat a difficult formula. (If you asked my colleagues they would tell you I really do dance 😉)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!