Do you have a dumb question that you're kind of embarrassed to ask in the main thread? Is there something you're just not sure about?
This is your opportunity to ask questions. No question too simple or too silly.
Culture war topics are accepted, and proposals for a better intro post are appreciated.
Jump in the discussion.
No email address required.
Notes -
I think you could easily accomplish this with most spreadsheet programs with little upkeep. Have your data sheet with the list of all your items, have your "packing" sheet with drop downs, and then have a sum cell with a formula which sums added vlookups. The vlookups will use the drop down cell to find the weight in the data sheet and then add all the weights together, e.g., "=(vlookup(A1, Shelter!A1:D14, 4, false))+(vlookup(A1, Clothing!A10:D20, 4, false))" and repeat for however many categories with A being the item list and D being the weight. For quantities you could add another column with that number in between the dropdown boxes and then include that in sum formula cell.
The dropdown cells can autopopulate choices from your datasheet if you designate the list range. If you do it this way, the only "upkeep" would be to fill out the item and the weight in the appropriate range for that category of equipment and the dropdown selection should autopopulate from that sheet or list. You could use different sheets for each category and have that sheet be the designated range.
More options
Context Copy link