Sum Of Children Not Working
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
-
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.
Answers
-
Exactly how is the data being pulled in, and how is it set up on the source sheet? Are you able to remove all formatting of the columns so that we can see if it is left or right justified? Numbers will be right justified and text values will be left justified by default.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
-
@Nicole J I am glad it is working for you now, but you may want to reach out to Support. The alignment itself should not impact the data type like that.
@Genevieve P. Have you seen any other instances of this? I feel like I might have seen a couple of other posts today where this could be a potential issue.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
👀
Hiya! Thanks for the tag, @Paul Newcome
I haven't actually seen this - the alignment of data should have no impact on formulas at all. @Nicole J if you can replicate this again, please contact our Support team to let them know about the unexpected behaviour and share more details about your sheet in a private channel.
Thanks!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!