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!
Best Answer
-
Sorry I meant greater than
=IF(COUNT(CHILDREN(Tasks@row)) > 1, "", rest of formula goes here
Answers
-
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
-
Sorry I meant greater than
=IF(COUNT(CHILDREN(Tasks@row)) > 1, "", rest of formula goes here
-
@Michael Culley - Amazing! That worked perfectly. Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!