Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

IF(Find) formula

Topic Labels: Formulas
1481 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Aly_Fossett
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,
I am having trouble with my IF(Find) formula. It is working for the first half of the formula but not catching the other "IF(Find). Here is what I have so far:

IF(FIND(‘TR’,{Name}),‘Trade’,IF(FIND(‘PR’,{Name}),‘Private’))

It is making them all “Trade” and not picking up on the “Private”. Screenshot below for reference
Screen Shot 2021-08-26 at 10.16.05 AM

2 Replies 2

Hi @Aly_Fossett ,

In your screenshot, it looks to me like every entry DOES have an instance of ‘TR’ in the name that precedes any instances of ‘PR’.

Try specifying the demarcations you used in the name along with the letters to give you a more accurate target to FIND():

IF( FIND( '- TR -', {Name}), 'Trade', … etc

Duh - I totally looked over that. You are correct- thanks!