Multiple OR Search formula

Platform discussions Special workflows & use cases
1

I am trying to set a multiple OR search formula and coming up with errors - any suggestions would be appreciated

IF(SEARCH(“WTT”,{Name},1)>0,“WTT”," “,
IF(SEARCH(“RR”,{Name},1)>0,“RR”,” ")

2

Hi,

It looks like you forgot to add 1 closing parentheses try this formula IF(SEARCH("WTT", {Name},1) > 0, "WTT", IF(SEARCH("RR", {Name},1) > 0, "RR", " "))

Hope this helps

1 Like