troubleshooting colors in Calendar App

florian.zbinden7

hello,

I have built some good looking roadmaps with the Calendar App. They are integrated within dashboards, really great tool.

I have one issue though; I went through some older posts on the SS Community and I believe this issue was not troubleshot, although raised (ref1, ref2).

My case : in the screenshot "end goal", you can see that I would like to achieve ; the colors of the first 2 columns (defined in Data grouping from tab 3) should match the one in the calendar part (or vice-versa, I don't mind as long as I can decide by myself the color).

I have tried to do so by using my sheet as a source and a report too, with the columns "Phase" and "Status" being as free text and dropdown list (I tried all combinations of options, no chance to get it to work as I expect).

Here is the configuration of the Calendar :

No config done on the tab 4 has any impact on colors, based on my tests.

Does anyone has any idea on how to get these colors match ?

Any help would be greatly appreciated, thanks in advance !

Best regards,

Florian

Genevieve P.

Hi @florian.zbinden7

Aha! Thank you for this, I was able to replicate this when the data grouping was done on a column that only had numeric values:

I adjusted the dropdown column to have text instead of numbers, and now the colours are reflected properly:

Would you be able to change your numbers to contain text and see if that then helps?

Thanks!

Genevieve

SteyJ

https://community.smartsheet.com/discussion/112911/troubleshooting-colors-in-calendar-app

Err this looks like the phase is confused what colors its suppose to be (obviously)

try changing tab 5 - Time & Design "Color by View" to status instead of phase.

florian.zbinden7

hi,

thanks for the advice ; unfortunately, I tired but this does not work.

This look like this :

in phase 2 for example, all modules should be in orange.

Any other idea for testing ?

Genevieve P.

Hi @florian.zbinden7

I'm unable to replicate this - my tab 5 setting colours update to the colour I select.

Can you try not assigning any column at all to that field? If you don't set a colour in the "Colour by Column" selection, it should default to the Data Grouping colours.

florian.zbinden7

hi @Genevieve P.

thanks for trying. I did remove the selection as you said

the outcome is that the colors match between the phase column and the swimlanes

but they are not the ones I selected in tab 3 unfortunately.

Phase 1 should be blue but it's yellow.

Strange.

Genevieve P.

Hi @florian.zbinden7

Aha! Thank you for this, I was able to replicate this when the data grouping was done on a column that only had numeric values:

I adjusted the dropdown column to have text instead of numbers, and now the colours are reflected properly:

Would you be able to change your numbers to contain text and see if that then helps?

Thanks!

Genevieve

florian.zbinden7

👏 high 5 to you @Genevieve P. , your solution works just fine !