-
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…
