Search multiple numbers (not text) with OR?

Mark Lappegaard

PROBLEM: Per below, it's possible to use OR to find results containing included words. But it doesn't seem to work for numbers.

BACKGROUND: I have a long list of product numbers from another system. To see if they are in Smartsheet, I copy and paste them into the search box, one at a time. This is boring and slow. I would rather put the whole list into the search box with each product number separated by OR. For example: "00001 OR 0002 OR 0003"

Advice?

Use search to find Smartsheet items | Smartsheet Learning Center

Nick Korna

Is your long list able to be pasted into Smartsheet? If so, you could use an IF & MATCH combo to find which are able to be found and which are not with a cross sheet reference to your existing parts listing by using something like this as a column formula:

=IFERROR(IF(MATCH([Search number column]@row, {Smartsheet part list column}, 0) > 0, "Found"), "Not found")

Sample data:

Cross sheet check:

As you can see, it should work for numbers and text.

Hope this helps, but if I've misunderstood something or you've any problems/questions then just post! 🙂

Mark Lappegaard

Wow, @Nick Korna. That is a clever approach. Nice idea. Thanks for that and the well laid out instructions. :)

Nick Korna

Is your long list able to be pasted into Smartsheet? If so, you could use an IF & MATCH combo to find which are able to be found and which are not with a cross sheet reference to your existing parts listing by using something like this as a column formula:

=IFERROR(IF(MATCH([Search number column]@row, {Smartsheet part list column}, 0) > 0, "Found"), "Not found")

Sample data:

Cross sheet check:

As you can see, it should work for numbers and text.

Hope this helps, but if I've misunderstood something or you've any problems/questions then just post! 🙂

Mark Lappegaard

Wow, @Nick Korna. That is a clever approach. Nice idea. Thanks for that and the well laid out instructions. :)