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!

Find more posts tagged with

Formulas

Countif

parent row

IF(

Child Rows

Accepted answers

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.