-
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…
-
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…
-
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.
-
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
-
Find the value just before Max?
I am trying to use Smartsheet to keep inventory of products I use incrementally but I am running into a formula issue that I am unable to solve. I have been using MAX(COLLECT()) to pull the most recent inventory check for an item, but I want to be able to pull the previous check as well so that I can compare how much…
-
How can I create a material inventory and order form in the same sheet
Hello, I am very new to Smartsheets and am trying to streamline inventory and how our partners order materials from us. Currently, partners email members of our team and someone fulfils and tracks the order manually in an excel sheet. I want to create a sheet that tracks inventory with an order form that subtracts from the…
-
I am really new and novice to this platform, hoping I could maybe get nudged in the right direction
Is there a way I could generate a running inventory of hardware i keep at my shop, which i distribute periodically to a couple work vans? The idea would be to take in hardware requests from the van drivers for replenishing their stock, and also receive updates with regards to what and how many pieces they use on jobs. All…
