You also cannot delete any of the individual tabs or columns. If you edit the overview page columns or rows, you can corrupt the formulas and it won’t work! There are formulas in place that auto-generate and fill in this page for you. However, the rest of the page should not be edited in any way. And, of course, please adjust your measurement units as often as you’d like! You can change the name to anything personalized you’d like to use. Your Inventory Overview page will also automatically sort in alphabetical order.ĭo not edit any of the fields on the Overview tab except the title (A1:G1) and the units (M2:N2). This will allow you to see your total freeze dried inventory in either cups, pints, quarts, or gallons.Īll fields and the summations will adjust to your preferred measurement unit as selected. To do this, simply select your preferred measurement units (M2:N2) using the dropdown and change as you’d like. After a lot of tinkering and trial and error – we figured out how to get this work, and it’s fantastic! You can adjust your unit size on any of the tabs and on the overview sheet to see your food storage by your preferred metric. However, in order to see my overall storage, I needed to be able to somehow combine and/or convert those units. I wanted to be able to store in a variety of sizes of mylar bags and jars, and record those by their actual packaging to make it helpful to find them in my storage bins and shelves. A cool feature we were able to add was the ability to adjust your unit of measurement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |