Report Color-Coding Multiple functions

Question

I cannot get my report for the Calendar to allow formula 1 to override formula 2? It is only using formula 2?

Case(ToText([Origin Name]),"lineage","#fce069",
Case(ToText([Shipment Status]),"Delivered","#dadada", "Booked","#f0f0f0", "Rated","#f0f0f0", "Scheduled","#f0f0f0", "In Transit","#f0f0f0", "Delivered ; In Transit","#f0f0f0"))

------------------------------
Alycn Bjergo-Justen
------------------------------

MarkShnierYou · Answer

try thisIF(ToText([Origin Name]),"lineage","#fce069",Case(ToText([Shipment Status]),"Delivered","#dadada", "Booked","#f0f0f0", "Rated","#f0f0f0", "Scheduled","#f0f0f0", "In Transit","#f0f0f0", "Delivered ; In Transit","#f0f0f0"))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community