Coloring Columns in a Structure in different colors

Holt Boyle

Hi,

I'm formatting my structure and for better visualization I want to color for example my assignee columne every assigne in a different color. Is that possible?

I have seen some formulars, but nothing has worked for me really. So please let me know thanks.

Stepan Kholodov

Hello @Holt Boyle 

The coloring can indeed be done via the Formula column. For example, here is the formula you can use for displaying the Assignee value with different colors based on the user:

if assignee = "user1" : concat("{color:red}",assignee,"{color}") else
if assignee = "user2" : concat("{color:yellow}",assignee,"{color}") else
if assignee = "user3" : concat("{color:green}",assignee,"{color}")

You can add as many conditions as you need using the else operator. The format of the column should be Wiki Markup. 
Alternatively, you can color the whole cell by using a different markup defining color codes for each value:
concat("{panel:bgColor=#248f24}",assignee,"{panel}")

I hope this helps. If you need further assistance, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo