Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 09, 2021 01:09 AM
Hi Am fine with IF(FIND) formula when I want different outcomes but not sure how to set up when I want all outcomes to be the same. I know the outcome from AND/OR will be 1 or 0 which I can then work from but need help with how to write the actual formula!
Below is my template formula I use to remember the IF(FIND) formula and adapt to whatever I need - if it helps to show me what I need to add where please use
IF(FIND(“search#word”, {search#field}), “the#result”)
Any help really appreciated have been searching but not finding yet.
Thank you
Nov 09, 2021 01:17 AM
Hey @Maria,
what do you mean ‘all outcomes to be the same’?
Have you ever tried switch formula it may works for you.
Thanks
Dimitris Goudis
Nov 09, 2021 01:28 AM
Wow! thanks for such speedy reply!
I am trying pull certain transactions from a bank statement that I don’t need to find paperwork for so the IF(FIND) conditions could come from multiple fields with different condtions which I can add to over time but the only result I want “no paperwork required” but also want option to easily change the result if I want to.
I am looking at your suggestion now to see if.
Thanks again!
Actually just realised I can do that by changing the formula I use to pull info from OR result ie. 1 or 0
Nov 09, 2021 01:32 AM
Think the OR formula is more flexible for what I want as the conditions are so variable. What do you think now after my previous reply?
Nov 09, 2021 02:04 AM
Without having clear in mind what do you want to create, I recommend you to embed the Find() in the OR() like this: IF(OR(FIND(),…,FIND()),“return if at least one find returns a value”, “return if no matches in find functions”
Does it work for you?
Thanks
Nov 09, 2021 04:20 AM
Thanks. Looks like what I what but really confused how to put my example into yours?
IF(FIND(“search#word”, {search#field}), “the#result”)
into your solution.
As obviously I don’t need the “the#result” bit as that will come from your formula but don’t know how to make it work?
Thank you
Nov 10, 2021 11:30 AM
Let me give you an example:
lets say that you want make a search into 2 fields the {Field 1 text} and the {Field 2 text} for a specific key_word in each case:
the formula is: IF(OR(FIND("client",{Field 1 text}),FIND("text11",{Field 2 text})),"matched","nothing match")
or in a more readable view:
IF(
OR(
FIND("client",{Field 1 text}), FIND("text11",{Field 2 text})
),
"matched", "nothing match")
Please keep in mind that:
If this answer doesn’t help you please feel free to text me dm to give me more info on the issue.
Thanks
Dimitris Goudis
my sample base to see the results is here: