Formula to search another smartsheet for a specific ISBN number

Trying to create a formula that will search an entire smartsheet for a specific ISBN that could be in one of 5 columns. Once located, I then want to create formulas that will provide additional information about that ISBN number in rows that follows that are also in different columns on the sheet. And then want to insert this sheet on a dashboard as a robust type of search tool! Ideas anyone?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!