Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the correct place/format. I know how to do this with Excel but what tool would I use in Smartsheet?
A form is for filling out information to add to a sheet, a report is a summary of a sheet, and a dashboard (to my knowledge) doesn't have the capabilities that I am looking for.
Answers
-
You would use an INDEX/MATCH formula with cross sheet references.
-
Would this go in a sheet? Dashboard? Report? How do I get it so I can print it out and the fields are in the correct spots instead of just a row of information?
-
You would have a reference sheet that has your part numbers and pertinent information. Then you would use a formula in another sheet with cross sheet references to pull the data in based on the part selection.
=INDEX({Reference Table Color Column}, MATCH([Part Number]@row, {Reference Table Part Number Column}, 0))
-
I already have a sheet with all of the data for each part on it. Is a sheet the best thing to use so that I can print out all of the pertinent information but have it situated and formatted so that it visually acceptable on paper?... Rather than just printing a row of information
