ChrisNewsome
6 years agoQrew Captain
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:
So I tried to apply this idea to the users:
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
------------------------------
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
------------------------------