IF/COUNT and IF/SUM/CHILDREN Formula Help

Michelle Choate 2

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!

Protonsponge

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

Protonsponge

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

Paul Newcome

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.

Michelle Choate 2

https://community.smartsheet.com/discussion/comment/458643#Comment_458643

Thank you! That was exactly it!