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", ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think we will use an IF
IF(
IsNull([Salesperson]), "#color 3 hexcode",
[Salesperson]=User(), "#F0cd95",
"#eddd85")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
IF(
IsNull([Salesperson]), "#color 3 hexcode",
[Salesperson]=User(), "#F0cd95",
"#eddd85")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thank you! I knew it should be simple but it is Friday; my brain is mush :)
------------------------------
Brianne Jacobsen
------------------------------
------------------------------
Brianne Jacobsen
------------------------------