Report Color-Coding Multiple functions
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]),"De...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
IF(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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Oh, I need it to contain the word Lineage in formula 1 - how can I write that?
------------------------------
Alycn Bjergo-Justen
------------------------------
------------------------------
Alycn Bjergo-Justen
------------------------------
- MarkShnier__YouIF(Contains(ToText([Origin Name]),"lineage"),"#fce069",
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thank you - that worked!
------------------------------
Alycn Bjergo-Justen
------------------------------