I'd like to display in apps different colors for the different hierarchical levels of a list. Is it possible please ?
Example : January & February in diffirent colors than Monday..
Currently different colors for the different hierarchical levels of a list is not available. If the list is in context selector then you can change the color of context selector but all the items will be same color irrespective of levels.
Ok thank you!
Actually, you can do this in the data fields but not in the first column where the list items are. In order to achieve such coloring you will have to learn how to use Ratio summary method for numbered line items.
This will allow you to set a level number for each level of the hierarchy within one line item.
Let's say you have two levels as in your example.
To make coloring you will have to somehow mark the level for each hierarchy member.
List member
Level
January
1
Monday
2
Tuesday
Wednesday
….
February
…
To calculate this you need one line item per each level for your hierarchy and another one line item named "1".
In your case two levels:
Line item Level 1 (applied by Months list) with formula = 1 and summary method = None
Line item Level 2 (applied by Weekdays list) with formula = 2 and summary method = Ratio (Ratio = 'Level 1' / '1')
This will give you ones and twos in the respective hierarchy levels in line item Level 2.
Then Level 2 can be used in Color Formating in any grid.
This is the example of the result of a three-level hierarchy: Each level is represented by a different shade of blue.
You can apply the same line item for all columns on your table.
Additionally, you can add any other coloring on top of this one, just add more IFs in your resulting Color formatting line item.
@KirillKuznetsov by using the idea mentioned by you we can apply conditional formatting for data different levels. But @rmamoune form the question it seems like different colors for the list items of different hierarchical levels of a list is my understanding correct, can you confirm.
@SriNitya you are right. I am just giving @rmamoune a working workaround that works for many end users where i implemented a similar thing
@KirillKuznetsov good to know the workaround thanks for confirming that my understanding is correct.
@rmamoune have you managed to replicate the color coding?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
