Reaching for Specific Information Return

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.

Find more posts tagged with

Manufacturing

Sheets

Sharing and Collaboration

Reports

Product Development

Project Management

Cell linking

Comments

Paul Newcome

Have you looked into building reports?

MikeCorvin

I have glossed over it; however, can you use one report to seed information into several different sheets dependent upon a singular answer? IE If(Supplier = x) put information on X sheet but if(Supplier = y) put information on Y sheet? If not then I am stuck with the same problem as before.

Paul Newcome

You can reference entire workspaces and folders within a report. Assuming the layout of all of the sheets is that same, it will essentially create a "Master". When a cell is updated in a report and the report is saved, it will then automatically update the corresponding sheet that the row was pulled from.

MikeCorvin

I will learn more about them over the rest of the week and see if I can make it work for my needs.

MikeCorvin

Thank you Paul!

After looking through the reports section it does exactly what I need, by searching a specific column for an exact text string I can then build the report to not only pick and choose the columns I want to show, but also what order I want them in. This will of course allow me to format anything into the correct format for a Dashboard no matter how i make the initial sheet! This way i can exclude proprietary information and only share the need to know information with our suppliers, and by keeping it out of a work space I can set up several suppliers from the same sheet.

Many thanks,

Mike

Paul Newcome

Excellent! Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Mr
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…