Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF(Find) formula

Topic Labels: Formulas
196 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!