troubleshooting colors in Calendar App

florian.zbinden7 · 11/10/23

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. · 11/17/23

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 · 11/11/23

troubleshooting colors in Calendar App

florian.zbinden7

Nov 10, 2023

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).
https://us.v-cdn.net/6031209/uploads/43CUK5CGWAGB/end-goal.png
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).
https://us.v-cdn.net/6031209/uploads/CMN1V4UKW4US/source-sheet.png
Here is the configuration of the Calendar :
https://us.v-cdn.net/6031209/uploads/KTIZMFPYHFTW/config-3.png
https://us.v-cdn.net/6031209/uploads/E1ZBAWEMCK7P/config-5.png
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

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 · 11/13/23

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. · 11/16/23

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.