Skip to main content
Question

Color Coded Calendar Report Formula

  • August 27, 2021
  • 0 replies
  • 31 views

I have the calendar report with a color coded formula so that if the field "Salesperson" is the user it is one color, and if not user it is a different color. 
Case([Salesperson], User(), "#F0cd95", "#eddd85")

I'd like to add a third option/color, if the Salesperson is "Not the User but Not Blank".  This seems like it should be simple, however I'm drawing a complete blank about how to write this.

So, I'd like:
User = Color 1
Not User = Color 2
Blank = Color 3

Any help would be appreciated.
Thanks


------------------------------
Brianne Jacobsen
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I think we will use an IF

IF(
IsNull([Salesperson]), "#color 3 hexcode",
[Salesperson]=User(), "#F0cd95",
"#eddd85")
​

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------