I have a color type column I’m using as a category for a calendar. For some reason Black won’t work? Every other color works except black? If I set the Result “Cancelled” As “Black” It turns blue and I don’t understand. If I tell it to be “Pink”, it works flawlessly.
My Color Column Expression is as follows:
IF([Type]=“Gig”,SWITCH(
[Status],
“Hold”, “Yellow”,
“Hold 2”, “Yellow”,
“Dead-Hold”, “Orange”,
“Confirmed (Need Details)”, “Red”,
“Confirmed”, “Red”,
“Cancelled”, “Black”,""),
SWITCH(
[Type],
“Request”,“Green”,
“Campaign”,“Blue”,"")
)
Any have thoughts?
LinkedIn
Twitter
