Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.


Colin Langman
edited 12/09/19 in Archived 2016 Posts


I have started an Inventory Control sheet for my husbands business.  He doesn't keep a lot of stock, but needs to know when things go in or out for ordering. I have set up the coloured balls to automatically indicate when stock is needed to be ordered, but would like to be able to automatically keep a running stock level.  So in otherwords, when stock comes in, we can check it off with a checkbox and it automatically updates the Qty in stock with the new order.  Hope I am making sense. 

Please help!




  • Kennedy Stomps

    Hi Colin-- To give me a better idea of what you're working with, can you share your sheet with me at Kennedy.Stomps@Smartsheet.com with Admin permissions? I'll take a look at it and see what we can do! :)

This discussion has been closed.