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!
Solved
Trying to create a formula to check if one field (text) contains another field (number) within a record
Best answer by Nick_Dennis
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")
+14Hi @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")
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!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.