How do I create a search tool within a sheet and referencing another sheet?


Hello everybody,

I am a new user of SmartSheet and I was recently assigned a project of building a search tool within a data sheet. I got a way of doing it on Excel but I would prefer to build something similar on SmartSheet. Does anybody have any idea or how can I get to do this?

Basically I have a master sheet like this with 178 countries and 12 different products, the sheet is to know if we are able to ship these products to these countries.

and then, with that information I built another sheet to make it easier to navigate through this information. It is basically just to filter the information out. The user will give the sheet a country, then a product, and the same sheet will return the answer if the product is available for shipping (Yes or No)

this is the formula I used on the Excel version, does anybody know if I could replicate something like this on SmartSheet?

Any help would be greatly appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!