Parent/Child color matching in Timeline View
Answers
-
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.
-
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:
-
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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)
-
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!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Top tip! Thanks @Genevieve P.
-
Thank you @KPH and @Genevieve P. ! I will try this out shortly.
-
No problem. Hope it works for you.
-
Just implemented it. Works exactly as I want it to and as you described. Thanks again!!
-
Great news. Glad I could help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives