Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formatting Parent Rows

SamS
✭✭
Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc
Thanks
Comments
-
Yes this is possible, but it requires the use of an aditional column. I leverage parent formatting for my projects.
Example: If the row is a parent row make it bold
- create a checkbox column and name it vParent (lock it)
- Enter: =COUNT(CHILDREN())
- Enter a formatting condition that addresses your criteria
If the vParent is 0 then green, 1 yellow, etc.
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives