Parent/Child color matching in Timeline View

System

This discussion was created from comments split from: Indented rows formatting.

Tigran M

I have a similar question… I would like the Children row formatting to match the Parent row, but I want to have a different Parent color for each Parent row. For example, if there is a Parent row called Fruits, and has 3 children called Apples, Pears, Plums, and a 2nd Parent row called Vegetables, with 3 children called Potatoes, Beets, and Carrots, Is there a way to make the rows Fruits, Apples, Pears, Plums all be 1 color and a the remaining 4 rows a different color, using Conditional formatting? I need this so that when I use the new Timeline view, I'd like the children colors to match the parent colors. This way in Timeline view, I would see the 3 fruit children be one color and the 3 Vegetable children be another color. Unless there is another way to make the colors be different in Timeline view, but I don't think there is. Hopefully my question makes sense. Thank you.

KPH

You could add a column to the sheet to identify the group each row belongs to and then set up conditional formatting based on the group column.

Assuming your hierarchy is just parent and child, and no other ancestors/descendants, your formula would be something like this:

=IF(COUNT(CHILDREN([Milestone Description]@row)) > 0, [Milestone Description]@row, PARENT([Milestone Description]@row))

This means if the row has more than 0 children, return the value in the Milestone Description column. If the row does not have children (and is therefore a child with a parent) return the value in the parent row of the Milestone Description column.

The conditional formatting would look something like:

Genevieve P.

@Tigran M - sending you an @mention notification to make sure you see the response from @KPH 🙂

KPH

Thanks @Genevieve P. FYI - I've been struggling to @ recently. The comment box seems to no longer let me make a spelling mistake. If I type a name and the drop down does not have the person I want, I backspace and correct, but the drop down then doesn't work. So unless the initial message is very short and I can see the name to type it in the reply, I am rarely able to remember the spelling on my first attempt! (chrome on PC and safari on mac)

Genevieve P.

Hey @KPH

I do that as well - if the @ ability disappears, save your comment as a Draft. This "refreshes" it so that you can @mention again!

KPH

Top tip! Thanks @Genevieve P.

Tigran M

Thank you @KPH and @Genevieve P. ! I will try this out shortly.

KPH

No problem. Hope it works for you.

Tigran M

Just implemented it. Works exactly as I want it to and as you described. Thanks again!!

KPH

Great news. Glad I could help!