Vendor Number: List the unique vendor number for each asset.Total Value: Review the cumulative value for each asset (by multiplying the quantity by the asset value).Asset Value: Provide the monetary value for each asset.Quantity: Enter the number available of each asset.Condition: Enter the status for each individual asset.Warranty Expiry Date: Provide the warranty expiration date.Purchase Price Per Item: List the purchase price.Date of Last Order: Enter a date for the last time each asset was ordered.Space: Provide details of exactly where each asset is located.Department: List the department where each asset is currently located.Type: List the type of each asset (e.g., computer hardware or software).Description: Provide a brief description.Item Number: Provide the unique identifying number for each individual asset.Having a single, reliable, centralized source to account for all of your assets can save your organization time, resources, and money.Īn asset tracking spreadsheet or template typically includes the following components for managing and tracking your organization’s assets: Whether you’re in information technology (IT), fixed asset management, enterprise asset management, infrastructure asset management, or other fields, you know how crucial it is to track your assets. Use an asset tracking template to track reorder levels and cost per item, and to calculate your assets’ total value. Getting started with the Smartsheet APIĪn asset tracking spreadsheet is a tool for cataloging, managing, and tracking assets by name, ID number, vendor, and category.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.Partners Learn about the Smartsheet partner program and access our partner directory.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.

Microsoft excel spreadsheet examples