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
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Ruby,

Since this is a temporary use you can do one long list:

If (  [Company1], "Yellow")=true, "Yellow,
[Company2], "Yellow")=true, "Yellow",
[Company3], "Yellow")=true, "Yellow",
[Company4], "Yellow")=true, "Yellow",
[Company1], "Red")=true, "Red",
[Company2], "Red")=true, "Red",
[Company3], "Red")=true, "Red",
[Company4], "Red")=true, "Red",  "Not Red or Yellow"  )


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------