Feb 11, 2019 05:54 AM
Is it possible to do a formula on a search wherein one statement search for 2 pieces of text in 2 columns? So I have one search
SEARCH("Walker", PRODUCT)
but I would like a search to also check SEARCH("scotch", TYPE)
Is it possible to combine those 2 statements into one formula?
Feb 11, 2019 05:58 AM
Yes, what you want to do then with both results? You have AND
function and &
operator, for instance.
Feb 11, 2019 06:01 AM
I just want it to return the rows that fit either one of the search statements. There is no need for a AND statement.
Feb 11, 2019 06:07 AM
You have the OR function too. With an IF, you could output an emoji or word. You also could use Views to Filter the records and only see the desired ones.
Feb 11, 2019 06:12 AM
I need a formula because I am accessing my table via the API and its requesting a formula
Feb 12, 2019 10:52 AM
This worked for me
IF(OR(SEARCH("word to search for", PRODUCT,)) > 0, (SEARCH("word to search for", TYPE, 10) > 0))