-
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…
-
Invalid Value Error in some rows of a Formula Column
I have an inventory transaction sheet that I have been working on for a little bit now. Looking at my Stock Alerts column again, it looks like there is an issue. The purpose of this column is to alert if the quantity requested is greater than or equal to the current quantity. If there is an error, then flag that the item…
-
Smartsheet Integration With Coupa
Coupa is a cloud-based business spend management (BSM) platform that helps organizations manage their spending across procurement, supply chain, and finance. Coupa provides visibility and control over how companies spend money, optimize supply chains, and manage liquidity. Coupa's platform automates approval workflows,…
