Index, Collect, with Contains

I have tried this multiple ways and it's still not working. Any ideas would be greatly appreciated.

Source data:

Destination sheet:

Into the Destination sheet, I want to pull the "Task Start Date" where the Client Name and Customer Name match and where the Source "Task Description" includes "Nursing". The source sheet may contain multiple rows that meet that criteria and I just need the first occurrence.

Thank you in advance!

Jennifer

Tags:

Best Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @JSpears

    The syntax of your CONTAINS needs slight tweaking

    Replace your CONTAINS with this:

    CONTAINS("Nursing",@cell)

    The rest of your formula will remain the same

    Kelly

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    Answer ✓

    Hi @JSpears , That looks pretty close. CONTAINS() syntax should be:

    CONTAINS("Nursing", @Cell)

    If that doesn't get it to work, I would try each condition on its own to see if one of them is not finding the match you want.

    Be well

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @JSpears

    The syntax of your CONTAINS needs slight tweaking

    Replace your CONTAINS with this:

    CONTAINS("Nursing",@cell)

    The rest of your formula will remain the same

    Kelly

  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    Answer ✓

    Hi @JSpears , That looks pretty close. CONTAINS() syntax should be:

    CONTAINS("Nursing", @Cell)

    If that doesn't get it to work, I would try each condition on its own to see if one of them is not finding the match you want.

    Be well

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!