Reaching for Specific Information Return

MikeCorvin
MikeCorvin ✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it.  I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire row as a result.  I would use this to build individual supplier sheets for review while allowing our production staff to only have to monitor/edit one sheet.

Comments