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]),"Delivered","#dadada", "Booked","#f0f0f0", "Rated","#f0f0f0", "Scheduled","#f0f0f0", "In Transit","#f0f0f0", "Delivered ; In Transit","#f0f0f0"))

------------------------------
Alycn Bjergo-Justen
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    try 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
    ------------------------------
    • 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
        ------------------------------