Sum Children formula
Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows.
Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0")
There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula returns with a 0. I have ensured that the rows are indented correctly. This happens everywhere I use these formulas together.
UPDATE: I have also found this issue when trying to add the child rows:
=SUM([Late Tasks]43:[Late Tasks]46
Best Answer
-
Try removing the quotes from around your numbers. Putting quotes around them turns them into a text string as opposed to a numerical value.
Answers
-
Try removing the quotes from around your numbers. Putting quotes around them turns them into a text string as opposed to a numerical value.
-
You're a genius! Thank you!
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!