Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
7 years ago

Can a formula field IF check if a value is in a list of values?

I have a formula field where I'd like to check if the value in a field is contained in a list of values IF([Field1] in [1, 2, 5, 10], "Yes", "No") Is this possible somehow?_  If the value in Field...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
You are safer with the IF and listing all the values lie you did in our example.  The "Contains" function is really for text values and you will get messed up between for example, 1 and 10 where they both contain a 1.

With numeric values you should use the formula you suggested where the conditions are listed vertically.