Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago

Color coding by user on a calendar report

So we have about 6 sales people, and I'd like to generate a calendar report to see what they're all doing each week at a glance. That's easy enough. However, their activities are all the same color, so I looked into color coding the activities by user. The quick option doesn't list my "scheduled for" field (which is where the user's name appears, and how I filter the report), so I tried to write a formula, but i'm running into a formula error I can't seem to solve. Here's what I've done successfully in the past to get colors:

Case([Activity Type],"Collect Payment","#3cc151", "Courtesy Call","#a874cb", "Create Change Order","#6791a8",)​

So I tried to apply this idea to the users:

Case([Scheduled For],"USER1 NAME","#3cc151", "USER2 NAME","#a874cb",)​


USER1 NAME is actually the person's name as listed in qbase. I also tried using their associate email addresses.


So I get an error that says "Expecting user but found text." How else would I reference the user? Is this just not possible on reports?


------------------------------
Thanks,
Chris Newsome
------------------------------

2 Replies

    • ChrisNewsome's avatar
      ChrisNewsome
      Qrew Captain
      Once again Mark saves the day. Worked perfectly. I couldn't find an instance of this issue anywhere on the discussions. Hopefully this helps many more people.

      ------------------------------
      Thanks,
      Chris Newsome
      ------------------------------