A shared stock list in Google Sheets™ with guardrails
Stock and inventory sheets carry quantities, prices and totals that everyone updates: numbers stored as text, reorder formulas typed over, SKUs duplicated.
What the guardrails add
- Quantity and price columns that only take numbers
- Totals and reorder formulas protected
- Duplicate SKUs found
- Numbers stored as text found before they drop out of SUM
Everything is a native Google Sheets™ feature, so it works for everyone on every device — nobody else installs anything. Take it all off in one click, free.
Start from a template
Make a copy of the stock list template — guardrails already on: the category dropdown and the quantity, reorder-level and price rules refuse anything else, the reorder and value formulas warn before anyone types over them, problems highlight in red, and each header explains its column. Or open your own stock list and choose Extensions › Shared Sheet Guardrails › Check this sheet.