Search a specific value within a range

01/14/22
Accepted

Hi, in this example, I would like to search a value (each cell in Column 5), within a range in Column4. I tried using formula HAS and CONTAINS, but it seems the criteria or search value is not recognized when I click on a cell in Column 5.

Appreciate if you can help me to find a way to pull this off.

Best regards,

Tags:

Best Answer

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @lschek1

    I agree that it would be helpful to know a bit more about what you're looking to do! Are you just checking to see if the value in your Column5 appears anywhere in Column4?

    If so, try something like this:

    =IF(CONTAINS([Column5]@row, [Column4]:[Column4]), "Yes", "No")

    Cheers,

    Genevieve

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @lschek1

    I hope you're well and safe!

    Can you share the formula you're testing and elaborate on what's not working?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Genevieve P.Genevieve P. admin
    Answer ✓

    Hi @lschek1

    I agree that it would be helpful to know a bit more about what you're looking to do! Are you just checking to see if the value in your Column5 appears anywhere in Column4?

    If so, try something like this:

    =IF(CONTAINS([Column5]@row, [Column4]:[Column4]), "Yes", "No")

    Cheers,

    Genevieve

  • Hi @Genevieve P. @Andrée Starå , yes I was able to solve, I changed something in the formula and did something similar to what Genevieve suggested. Many thanks.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @lschek1

    Excellent!

    Glad you got it working!

    Happy to help!

    Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.