IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula:
=IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN()))))
This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something sill and it may come to me first thing in the morning, but I thought I might ask the community to take a look too.
Thanks for your help!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Best Answer

Hello @Michelle Choate 2,
Are you using your [P] column as a levels column, if so the following formula may be helpful?
If I read correctly, I think you are looking to have 1 in [Sheet Needed] column, if [Sheet Created] is checked and if the row is a parent row, you would like to sum the children?
=IF(P@row = 0, SUM(CHILDREN()), IF(P@row = 1, IF([Sheet Created?]@row = 1, 1, 0), " "))
I hope that is helpful to you in someway,
Protonsponge
Answers

Hello @Michelle Choate 2,
Are you using your [P] column as a levels column, if so the following formula may be helpful?
If I read correctly, I think you are looking to have 1 in [Sheet Needed] column, if [Sheet Created] is checked and if the row is a parent row, you would like to sum the children?
=IF(P@row = 0, SUM(CHILDREN()), IF(P@row = 1, IF([Sheet Created?]@row = 1, 1, 0), " "))
I hope that is helpful to you in someway,
Protonsponge

Try moving one of the closing parenthesis from the end to close out the COUNT function before the comma to move on to the second IF statement.

Thank you! That was exactly it!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!