-
I'm trying to create a tracking system using two sheets.
One sheet is the Gift Card Quantities has the number of existing gift cards in each dollar amount and the other is a tracker that allows the user to enter the gift card used, dollar amount, quantity of gift cards. What I want to do is if a $50 dollar gift card is used, then that number is subtracted from the existing…
-
Batch QR Code Generation, Scanning, and Database Management
I need a way to generate batch QR codes in Smartsheet that are tied to individual line items in a Smartsheet inventory database. Each line item includes multiple column categories (e.g., date received, item type, quantity, lot #, shipment state). Process: Inventory manager submits a Smartsheet form for each shipment,…
-
Column to Column: Activating set values in a column
Hello, I am trying to develop an inventory sheet for thousands of products. I have everything categorized under (8) main categories. Is it possible to have specific set of subcategories to populate in the next column (as a drop down option) depending on the parent category? I am trying to limit the number of options in the…
-
adding and subtracting from inventory sheet based on orders
Hello, what im trying to accomplice is when selecting a item in the drop down menu "equipment shipped" for example "logitech". i would like it to subtract a quantity of 1. example, we have 200 and in our inventory sheet. i would like it to look at our inventory sheet and subtract 1. i would also like to do this with if we…
-
Subtraction formula with conditional IF statement from cells populated from index match
Hi everyone, I'm trying to create an inventory spreadsheet that auto calculates the QTY in the warehouse by subtracting the amount received from the amount signed out. These columns are populated via an index match formula cross referencing another sheet. I also need there to be the caveat that if nothing has been signed…
-
Core Return Tracking
Hello, I am currently working on setting up a Core Return Tracking workspace. We plan to track all of our parts in the system by adding them to a master sheet via a form. Once a part is sold, we want the warehouse guy to be able to use a form type setup and just have to enter details on a few of the columns to update the…
-
Inventory Management System
I am looking for a way to have our maintenance team be able to manage a stock inventory on specific machine parts. I would like for them to use their phones to scan on to either the QR or barcode and it reference my sheet. From there they could update the inventory, and I would have automation set up to alert that an…
-
Inventory and Barcodes
Hey there! I have a question regarding inventory management and barcode scanning. Currently I have a sheet called "inventory tracker". We have various different lab supplies that need are deployed depending on the need. Currently, we are manually counting how many supplies we take out and whatever is not used, we count and…
-
How do I set up an inventory management system in Smartsheet?
Hello, I'm looking for help setting up an inventory management system in Smartsheet. We have a set number of chairs, tables, linens, projectors, etc. that various departments at my organization use each day. I'm looking to create a system where they can input their daily needs, and it will show how many of each item is…
-
Alerts when X ammounts of items arrive for project X
Backround: I work with custom computers, its only me myself and i in my department so i am looking to automate as much as possible. I have a sheet where i enter every part that arrives and which Project number it belongs to, what Serial number the part has and the parts EAN code. Goal: I would love if i could set up a…
-
How do I track our mushroom inventory?
I have created multiple sheets that are inputted through forms for the team to update. The team updates the inventory based on the tent, mushroom type harvested and how many pounds. We need an up to date tracking of the inventory of each type of mushroom. At minimum I need to figure this out. Advanced would be to be able…
-
If(Contains) issue
I am trying to look at a column on one sheet and if it contains a certain value or multiple of the values that I am searching for, return a sum of value(s) from one or more specific cells that are contained in a separate sheet, otherwise return as 0 or as if nothing has happened. This is the formula I have come up with but…
-
Help with Supply Inventory & Checkout Tracker
I made an inventory tracker to keep track of our supplies, and on a separate sheet I made a tracker for requests to check-out supplies and a form for this. I want people to be able to select multiple items on the form. The issue I am running into is that I had created a formula to pull the number we have “In Stock” from…
-
Inventory Request Tracking
Hello, I am trying to set up an inventory request system. I seem to only be able to find templates for request trackers and inventory trackers, not a way to link the two. How can I create an inventory list and then a form where users can request use of items in the inventory and I can track when items are checked in/out…
-
QR scan from Form
Can you make your camera pop up to scan a QR when you click in the Item box on this form? Trying to make this easy for customers to scan out inventory Onces scanned out it will go over to the smartsheet and send a notification.
-
Inventory Management with Dynamic feature for Reagent Depletion from Assays Performed
I currently work in a lab that is looking to up their game on inventory management. We have an inventory smartsheet that gets updated after technicians manually check inventory in lab and update the sheet. Naturally, reagents get missed and our smartsheet becomes inaccurate very quickly. I'm trying to figure out a way to…
-
trying to create a check out sheet to add inventory quantity to inventory sheet
im looking into trying to make a checkout sheet that hold serial numebrs of products to an inventory sheet and to add those serial numbers, also to locate duplicates and delete the duplicates serial number found. this is the sheet we will be taking orders and using row serial number to either add or subtract from our…
-
Employee Product Purchase Program
Hello! Currently we are tracking leftover furniture product for sale to employees using a basic smartsheet. We want to be able to allow all employees to view product details and photos of the product for sale AND be able to request the items they want to purchase (first come, first serve). My first thought is to use…
-
I want to create a very basic stock management sheet. adding in stock updates quantity and
removing stock updates the quantity. I cannot figure out what the easiest method would be without creating a loop because if I add stock I would have to keep upping the numbers of that column. If I already had a quantity of 20 water bottles and then I got in another 20 bottles of water one week, and the next week I got…
-
Am I able to Scan a Barcode that contains both the SKU# and Lot Number ?
Can I scan a barcode that contains two sets of info but have them populate in two different cells? Could I then have different sets of qtys for each lot? For example have a SKU# B456 and a Lot# of the item with its own qty. SKU# B456 Lot#77625 -2 Lot#77888-15