Best way to display product information
I am creating a master sheet with information from several different cross functional teams, including dimensions, features, product images, product availability date, etc. We are at about 175 columns total at the moment, and as you can imagine, finding information is time consuming.
I'd like for people to be able to select a particular model, and then be sent to another sheet (or dashboard) that can then display all the information for the product, including giftbox and master carton dimensions (which are standard across all colors), the colors available (either in stock or able to be produced), as well as color specific links to images, all of which are listed on the master information spreadsheet.
Currently we are listing each color/country combination as a separate line item as well.