-
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,…
-
Inventory management. Is there a way to remove the manual removal/addition of component counts?
I have a Smartsheet inventory log for multiple projects. To make a complete build, it may require 1-5 of each component. I am wondering if there is a way to create a sheet with these pre-determined component amounts needed for one build, input the number of builds required and then have that communicate to the inventory…
-
Simple Inventory Formula
Help, maybe I am overthinking this or going about it all wrong. I'm trying to create a SIMPLE inventory tracker, it does not include costs. I have a request form where users request an item and I want to subtract it from the existing stock on hand, be able to replenish inventory and adjust inventory if someone audits the…