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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.