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!!!
Solved! Go to Solution.
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