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

4 Replies

  • 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
    [email protected]
    ------------------------------
    • 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
      ------------------------------