BrianneJacobsen
5 years agoQrew Trainee
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
------------------------------
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
------------------------------