Formatting requirement on Dashboard

Hi, I have a requirement where users want to have ability to add space line in rows for formatting purpose. I tried to use header formatting, add special character lineitem (such as --------) to do so... But none of them is accceptable by users. Second requirement is color in the list member. I tried to use conditional formating but users want to have color in list member (label/master data) also. Is there any improvment in near future on product roadmap that can let us to do these formatting requirement? Thanks a lot, Huy.

Accepted answers

All comments

harish_bk

Hi Huy

For now I do not see any option but we can try using Excel or PPT Addin and see if it helps, Addins are still in their primitive stages though.

peter_mcanena

You can't have blank line items, or even line items with leading spaces in their names. All you can do is give them almost-blank names like . or - (i.e. a full stop or a hyphen).

There's also no way to change the colour of the line items names. Conditional formatting only works on cells with data in them (i.e. in the body of a table).

Sorry.

SEllis

Hi Huy,

i know that "#------#" will work as a list item name.

Here is an example of a dashboard I mocked up to show hierarchical spacing. It required the creation of a mirror list, and a mapping between the mirrors. I'll illustrate:

1) Create a mirror List

2) Establish a list property linking the mirror to the original list

3) Execute a formula using the LOOKUP function

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…