Disable summary values on parent rows

Hello! I have set up my project list to contain a topic area (blue), sup-topic area (gray), and tasks. Since the actual tasks are technically "sub-tasks", the data in the parent rows are summary values. This information is not super helpful/relevant, especially the "Health" since it's not a very accurate depiction of the overall health. Is there a way to prevent the summarization, or has anyone set up their project sheets in a way that the topic areas aren't part of the task list? New to Smartsheet, so all suggestions are appreciated!

Thanks!

Find more posts tagged with

Accepted answers

Michael Culley

Sorry I meant greater than

=IF(COUNT(CHILDREN(Tasks@row)) > 1, "", rest of formula goes here

All comments

Michael Culley

You could add an if statement in front of the formula to see if it's a parent row and if so, let it be blank instead of having a status color.

=IF(COUNT(CHILDREN(Tasks@row)) < 1, "", rest of formula goes here

Michael Culley

Sorry I meant greater than

=IF(COUNT(CHILDREN(Tasks@row)) > 1, "", rest of formula goes here

Kadie M

@Michael Culley - Amazing! That worked perfectly. Thank you!!

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.