Skip to main content
Solved

Formula for Multiple Select Field - Returning result only if one item has been selected

  • February 13, 2021
  • 4 replies
  • 46 views
K

Hi, Apologies if this has been covered elsewhere. I’ve got a table with 3 fields:

Customer (Single Line Text)
Interests (Multiple Select Field)
VTS (Formula Field)

and I’m trying to get the VTS field to populate with the Customer Code if “VTS” has been selected in the Interests field.

I used the formula IF({Interests} = “VTS”, {Customer}) Screenshot 2021-02-13 231010|700x490
and it returned a result when “VTS” was the only item selected in the Interests field, but not when more than one option had been selected.

I’m assuming it’s the equals sign that needs editing, but I’m not sure what I need to replace it with. Any help would be much appreciated.

Best answer by augmented

Try

IF(Find(“VTS”,{Interests}) > 0,{Customer})

Cheers.

    4 replies

    A
    Forum|alt.badge.img+18
    • augmented
    • Inspiring
    • Answer
    • February 14, 2021

    Try

    IF(Find(“VTS”,{Interests}) > 0,{Customer})

    Cheers.

    K
    • Kelly_Bartholet
    • Author
    • New Participant
    • February 14, 2021

    Try

    IF(Find(“VTS”,{Interests}) > 0,{Customer})

    Cheers.


    Hi augmented. Thanks for your reply. I tried copy/pasting this into the formula field but it came up with the error message ‘Invalid formula. Please check your formula text’.

    I tried adding a space after the commas (that’s the extent of my trouble shooting abilities, LOL), but that didn’t change anything.

    A
    Forum|alt.badge.img+18
    • augmented
    • Inspiring
    • February 14, 2021

    Kelly, try removing the quotes around VTS and then type them in manually. Lots of quotes, when copy/pasted from elsewhere, come into Airtable as curly quotes. Those are not good.

    Otherwise, I’m stumped. Good luck.

    K
    • Kelly_Bartholet
    • Author
    • New Participant
    • February 14, 2021

    Kelly, try removing the quotes around VTS and then type them in manually. Lots of quotes, when copy/pasted from elsewhere, come into Airtable as curly quotes. Those are not good.

    Otherwise, I’m stumped. Good luck.


    That did the trick! Thanks again for your help. :slightly_smiling_face:

    Terms & ConditionsAccessibility statement