Forum Discussion

RubyKapil's avatar
RubyKapil
Qrew Trainee
6 years ago

Filter Across Similar Fields only shows Field 1 values

Need some formula help -- 4 Multi-Choice fields in same table: Company 1, Company 2, Company 3, Company 4. Each of these 4 fields has the same set of Choices: Red, Blue, Green, Yellow. Each record ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Maybe this is what you want
List(", ",
If(Contains([Company1234], "Yellow"), "Yellow")
If(Contains([Company1234], "Red"), "Red")
If(Contains([Company1234], "Blue"), "Blue")
If(Contains([Company1234], "Green"), "Green"))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • RubyKapil's avatar
    RubyKapil
    Qrew Trainee
    6 years ago
    Thanks Mark. The result I want is a Single value to show in the filter result, Green if any of the 4 companies have Green, Red if any of the 4 companies have Red.
    Blue,
    Green
    Red
    Yellow

    The List formula above is similar to my Company1234 field in that the filter results are: 
    Green
    Green, Red
    Red
    Red, Yellow


    ------------------------------
    Ruby Kapil
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      I guess I do not understand what you want to have happen if some of the companies have red and other have yellow and others have green.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------