Discussions

  • 1.  Color Coded Calendar Report Formula

    Posted 08-27-2021 13:35
    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.  RE: Color Coded Calendar Report Formula

    Posted 08-27-2021 13:38
    I think we will use an IF

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


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



  • 3.  RE: Color Coded Calendar Report Formula

    Posted 08-27-2021 13:47
    Thank you!  I knew it should be simple but it is Friday; my brain is mush :)

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