Help

Exactly match condition

Topic Labels: Automations Formulas
1967 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Selimafifi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, is there a way of Exactly match a word, I am trying to do an automation that includes Only "Capital" . the condition automatically returns any cell that has  Capital, and the whole point is to only return the cells that contain Capital by itself. in other words, in the look up sheet , there are cells that contain " Capital, XX company", the condition will return these as well as cells with the name alone. I want the cells with the name alone. 

on Excel you can exact Match. please help. 

1 Reply 1
Vic_Airtable
Community Manager
Community Manager

Hi @Selimafifi 

Could you check to see if you are using the option "is" instead of "contains" when building your automation?

If using "is" you should only have records returned that match exactly to "Capital" instead of all records that contain the word "Capital".