Checked By: Enter the name of the employee who checked each inventory item’s quantity, condition, and other relevant details.Counted By: Enter the name of the employee who counted each individual inventory item.Stock Location: Enter stock-location details for each inventory item.Item Status: Specify whether each item is available or has been discontinued.Item Reorder Quantity: Enter the quantity to be reordered for each item.Days per Reorder: Enter the days between order and receipt for each vendor and item.Total Inventory Value: Check to ensure that your inventory’s total value is correct by adding together the total value of all items.Total Value: Check to ensure that each inventory item’s total value is correct by multiplying item quantity and cost per item.Cost per Item: Enter the cost per item for each inventory item.Stock Quantity: Enter the in-stock number for each item.
Vendor: Enter vendor contact details, item number, and unit information for each item.Date of Last Order: Enter the specific date of each item’s most recent order.Description: Enter a brief description of the item.Item Name: Enter a name for each inventory item.Item Number: Enter a unique number for each item in your inventory.Reorder: Enter reorder details, including an item’s auto-fill threshold and whether the item is currently on order.A Google Sheets inventory template can help alert you when inventory items need to be reordered and keep your inventory proactively stocked.Ī Google Sheets inventory template typically includes the following details for managing and tracking your inventory: Whatever your role in inventory management, you know how critical it is to have accurate data and keep sufficient stock on hand. It also helps you track costs per item, stock quantities, and reorder levels, and calculates total inventory value. Getting started with the Smartsheet APIĪ Google Sheets inventory template helps you track and manage inventory items by name, number, reorder status, and vendor information.ENGAGE Smartsheet ENGAGE brings together our global customers, experts, and partners to share their experiences, ideas, and best practices.Smartsheet events Your hub for Smartsheet events, webinars, Q&As, and user groups.Open the basic Google Sheets weekly schedule template, save it ( File > Make a copy ), rename it, and choose a folder on your Google Drive. Download and Name the Basic Google Sheets Daily Schedule Template. Partners Learn about the Smartsheet partner program and access our partner directory. Here are the detailed steps to create a daily schedule: 1.Community Explore user-generated content and stay updated on our latest product features.Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet.Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform.