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.

Formulas

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

Hi,

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!

Thanks. 

Tags:

Comments

  • Kennedy Stomps
    Options

    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.