IF/COUNT and IF/SUM/CHILDREN Formula Help

Michelle Choate 2 · 10/17/24

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 · 10/17/24

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 · 10/17/24

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 · 10/17/24

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 · 10/17/24

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

Thank you! That was exactly it!

IF/COUNT and IF/SUM/CHILDREN Formula Help

Best Answer

Answers

Help Article Resources

Categories