Format Parent Rows Only with 'Helper' Columns Not Helping...

ForeverLearning

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!

Jason Tarpinian

It looks like the formatting you're changing is the Gantt bar schedule. To format the cell fill, use this format:

Jason Tarpinian

It looks like the formatting you're changing is the Gantt bar schedule. To format the cell fill, use this format:

ForeverLearning

😑 Can't believe I completely overlooked that! Thank you very much for the help!