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! Book time with me here: https://calendly.com/michelle-choate
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! Book time with me here: https://calendly.com/michelle-choate
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!