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
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
------------------------------