Disable summary values on parent rows

Kadie M

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!

Michael Culley

Sorry I meant greater than

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

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!!