And/Or function with IF

D.wilson

I am trying to figure out how to return a result using an "if" function that references a multi-select dropdown field. I want the formula to return a "1" ANY TIME a particular selection is made in the drop down, EVEN IF another selection is ALSO made in the drop down using the multi-select. Right now, the formula does not return a "1" if both my desired selection is checked and another selection is checked. I know I could write a formula that is super long and considers EVERY combination of selections in the drop down, but I am hoping there is a better way.

Thank you!

Paul Newcome

Try a HAS function.

=IF(HAS("text", [Column Name]@row), 1)

Paul Newcome

Try a HAS function.

=IF(HAS("text", [Column Name]@row), 1)

D.wilson

That was awesome! Thank you! Could use the OR function with the HAS function and that did the trick!

Paul Newcome

Happy to help. 👍️