Forum Discussion

AlycnBjergo-Jus's avatar
AlycnBjergo-Jus
Qrew Member
5 years ago

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...
Formulas and functions
reports and charts
AlycnBjergo-Jus's avatar
AlycnBjergo-Jus
Qrew Member
5 years ago
Oh, I need it to contain the word Lineage in formula 1 - how can I write that?

------------------------------
Alycn Bjergo-Justen
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
IF(Contains(ToText([Origin Name]),"lineage"),"#fce069",

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AlycnBjergo-Jus's avatar
    AlycnBjergo-Jus
    Qrew Member
    5 years ago
    Thank you - that worked!

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