Skip to main content
Question

Color Coding on Calendar App


I have a calendar report that color codes based on status, however I would like to modify it so that the report will "highlight" the jobs assigned to the current user by making them a slightly different color.  But my formula will only return the first set of colors no matter who is assigned the job.  Does anyone see an obvious error in my formula?
If([Related Employee]=User(),
Case([Bid/Estimate Status],"Started", "#1abc9c", "Submitted", "#a569bd", "Revised/re-quoted", "#85c1e9", "Bid Awarded", "#d65047", "#f4f2f5"),
Case([Bid/Estimate Status],"Started", "#27a38a", "Submitted", "#8b4da3", "Revised/Re-quoted", "#739eba", "Bid Awarded", "#f5a4d7", "#f4f2f5"))

------------------------------
Thanks, Brianne Jacobsen
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The field for [Related Employee] is likely the Record ID of the Employee record. Is that the problem?

Maybe  you need to lookup the userid of the employee to compare to the current User.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------