@@SimpleSheets Thanks! Do you know if there is a way to use it on Google sheets? I filled out a few items on the first tab, but there is no “refresh” function to manually update the second tab as far as I can see
We don't currently have a Bill of Materials template compatible for Google Sheets, but will definitely put that in our queue. We're developing new templates all the time, almost all of them focused on Excel at this point.
Wait, so in the title of the video, which YOU created, you say "Bill of Materials Excel and Google Sheets Compatible Template", yet then on the very first comment you respond with "We don't currently have a Bill of Materials template compatible for Google Sheets".....WTF?!?!?! Make up your mind! Also, can someone download this template without giving you their personal info (ie name & email address) AND without signing up for a free trial of a paid service?
Great complement to my Inventory Control system I built for my small business. I needed the companion BOM for my finished goods. I'll try the download.
What if I also wanted a column showing the retail cost of each component assuming my unit cost was purchased at wholesale and I wanted to build my sale price using the retail price of each component? That way I could see my actual build cost and retail sale price for the completed product especially if I wanted to set my pricing that way
Yes, absolutely. We've updated the template so if you signup for our free template trial you'll be able to access the BOM showing the retail cost of each component.