Forum Discussion

BrianneJacobsen's avatar
BrianneJacobsen
Qrew Trainee
3 years ago

Color Coded Calendar Report Formula

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
------------------------------

2 Replies

  • I think we will use an IF

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

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • BrianneJacobsen's avatar
      BrianneJacobsen
      Qrew Trainee
      Thank you!  I knew it should be simple but it is Friday; my brain is mush :)

      ------------------------------
      Brianne Jacobsen
      ------------------------------