Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello,
New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate each project.
I've read and created helper columns to base conditional formatting off of…
in the Level column:
=IF(COUNT(CHILDREN()) > 0, true, false)
in the Row Level column:
=COUNT(ANCESTORS()) + 1
Why are the parent rows with the level column checked, not highlighting the entire row? Thank you for your time and assistance!
Best Answer
-
It looks like the formatting you're changing is the Gantt bar schedule. To format the cell fill, use this format:
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Answers
-
It looks like the formatting you're changing is the Gantt bar schedule. To format the cell fill, use this format:
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
😑 Can't believe I completely overlooked that! Thank you very much for the help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives