SUMIF with CHILDREN, if greater than 0
I am just migrating to Smartsheet from Excel. Smartsheet is missing some basic things, but I'm trying it primarily because of the Indent/Children functions, which are something I love.
I've got some data in, and the =SUM(CHILDREN()) function works well, but I don't want a bunch of 0's all over my sheet, so I've been trying to get a SUMIF working with CHILDREN. I've tried countless combinations of formulas but I'm looking for something like this.
=SUMIF(CHILDREN()>0, "SUM(CHILDREN()", "")
Basically, I only want the SUM of the CHILDREN if the sum is greater than 0, otherwise I just want the cell blank.
Is this possible?
Best Answers
-
-
Hi @r0plbghdv,
I had some issues with this, but rather than a SUMIF I have used an IF statement which then counts the child rows beneath a row.
Have a look at this formula and see if it does what you want. You will need to replace the column reference in it.
=IF(COUNT(CHILDREN([Primary Column Name]@row)) <> 0, COUNT(CHILDREN([Primary Column Name]@row)), "")
Hope this helps!
John
Answers
-
-
Hi @r0plbghdv,
I had some issues with this, but rather than a SUMIF I have used an IF statement which then counts the child rows beneath a row.
Have a look at this formula and see if it does what you want. You will need to replace the column reference in it.
=IF(COUNT(CHILDREN([Primary Column Name]@row)) <> 0, COUNT(CHILDREN([Primary Column Name]@row)), "")
Hope this helps!
John
-
Those both worked, thank you very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!