Multiple Field formula

[Ragini1]

Hello Everyone,

I am trying to find out a solution to check value in multiple fields and if it has any value it will return Yes. I am using Multiple Field formula for that but am getting output as for all the fields which has transaction. Rather than that I want output as if any of the fields has transaction, it will return Yes. Is there any way.

Appreciate your help.

Thanks!!!

[OllieClarke]

If you have a limited number of columns, then you could use a normal formula such as:

IF CONTAINS([Field1],'transaction')
OR CONTAINS([Field2],'transaction')
OR CONTAINS([Field3],'transaction')
OR CONTAINS([Field4],'transaction')
THEN TRUE
ELSE FALSE
ENDIF

It could turn into an unwieldy formula though, so you could transpose your data and check that way too 

[OllieClarke · Accepted solution]

Here's another way of doing it @Ragini1: