Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 26, 2021 07:16 AM
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
Aug 26, 2021 07:46 AM
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
Aug 26, 2021 07:56 AM
Duh - I totally looked over that. You are correct- thanks!