Search a specific value within a range

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. Employee 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!