+3Hi,
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
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', … etcHi @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', … etcDuh - I totally looked over that. You are correct- thanks!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.