Not another teen spreadsheet.
No One: If only there was another spreadsheet I could bookmark to go with these five other spreadsheets.
Every 4 to 6 weeks, Snap refreshes 4-8 new meals on our 35+ menu. Each meal requires a packaging label replete with a Nutrition Facts panel, instructions, ingredients, etc. Additional dietary info needs to be added to snapkitchen.com, local.snapkitchen.com, and our iOS app. Marketing, Ops, Creative, Culinary, and Technology departments are involved and they all had different siloed spreadsheets.
Until one day. I took all of these.
And made….
A Master Meal Filter Sheet.
Formulas! Filters! Oh my!
The sheet is set up for various teams to input data to be shared cross-functionally. It automatically calculates tricky nutrition facts percentages, and extracts meaningful info from the ingredients list for filters. It is also set up to work with an InDesign data merge for both our packaging labels and shelf tags, transforming a task that took hours into one that only takes about 30 minutes.
NOTE: This isn’t the actual sheet, but a view-only copy.