Skip to content
Coffee !
Share
Explore
INVENTORY

INVENTORY FORM

Please fill out this form weekly to ensure proper stock. Please send the form using the button below!
CLEAR FORM

12/8/2021
Who is filling out this form?
Barbara
Lets try this
1
Search
Category
Item Name
Quantity Type
Amount
Coffee & Espresso
Coffee Beans
Count Individual
999999
Espresso Beans
Count Individual
999999
Decaf Beans
Count Individual
999999
Coffee Filter
Count By Case
999999
Cleaning Supplies
Espresso Cleaner
Count By Case
999999
Bleach
Count Individual
999999
Trash Bags (Rolls)
Count By Case
999999
Floor Cleaner
Count By Case
999999
Other Drinks
Iced Black Tea
Count By Case
999999
Iced Green Tea
Count By Case
999999
Iced Caffeinated tea
Count By Case
999999
Thai Tea
Count By Case
999999
Food Prep
Lettuce
Count Individual
999999
Tomato
Count By Case
999999
Bread buns
Count Individual
999999
Drink prep
Vanilla Syrup
Count Individual
999999
Caramel Syrup
Count Individual
999999
Hazelnut Syrup
Count Individual
999999
999999

Send

Find a formula or conditional format where if Quantity type is “checkbox” then the amount in the next column would have a checkbox. If Quantity type “individual” is selected, then amount column would be left blank/”0”.
Add if then statement: If quantity is less than/equal to ____, then item name would be listed in new table (preferably new page). When user clicks “send” button, an email would be sent with the new table to show items that are needed.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.