Sum Of Children Not Working

Nicole J
Nicole J ✭✭✭✭
edited 06/15/22 in Formulas and Functions

Anyone have any idea as to why the "=SUM(CHILDREN())" function won't actually work on certain columns?

In the attached image, you can see that "March 2022 Hours Scheduled" in Row 1 is accurately gathering the sum of its children. But "April 2022 Hours Scheduled" in Row 1 is not. "May 2022 Hours Scheduled" is working. But "June 2022 Hours Scheduled" is also not.

All children cells are formatted the same way, and I cannot tell any difference between anything.

Any advice?

Best Answer

  • Nicole J
    Nicole J ✭✭✭✭
    Answer ✓

    Thanks, Paul.

    By making all columns in the Source Sheet be "right aligned", that fixed it. It's now properly summing on my new sheet.

    Weird, but oh well.

    Mission accomplished.

    Thanks, again.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!