Help

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
1567 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Townsend
4 - Data Explorer
4 - Data Explorer

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
Nick_Dennis
7 - App Architect
7 - App Architect

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
Nick_Dennis
7 - App Architect
7 - App Architect

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!