Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Trying to create a formula to check if one field (text) contains another field (number) within a record

Topic Labels: Formulas
Solved
Jump to Solution
577 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Guys,
Having trouble finding out how to write a formula to check if one field contains another field’s data. The specific use case is data being pulled from an ecommerce site. Each order comes from a page dedicated to a suburb/postcode. Each order populates a record with this suburb/postcode in one field as well as the delivery address in another field. I am trying to create a formula that will check if the delivery address contains the same postcode in the other field (and if so label it “true”).
Any help would be much appreciated!
Thanks in advance!

1 Solution

Accepted Solutions

Hi @Paul_Townsend, welcome to the forums!

I think what you’re looking for is something like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True")

If you want to add a label for when it is false, just add it like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True", "False")

See Solution in Thread

2 Replies 2

Hi @Paul_Townsend, welcome to the forums!

I think what you’re looking for is something like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True")

If you want to add a label for when it is false, just add it like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True", "False")

Thanks a million Nick, that has done the trick! Was trying with the search function instead of the find!