Formula Question

I'm developing an inventory smartsheet that keeps clothing inventory in one sheet and then a form that allows an employee to request clothing for team members. I am working if I can create a formula to deduct the quantity of each clothing apparel once it is requested. There is no approval process needed.

Smartsheet 1: Kit Inventory

Smartsheet 2: Kit Requests





  • Naeem Ejaz
    Naeem Ejaz ✭✭✭✭

    Yes contact me on my number 00923455332351 or email me at [email protected]

    Executive Manager PMO


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Jason Mobley

    I hope you're well and safe!

    Have you checked the templates available in the Solution Center? They can be excellent starting points.

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Andree,

    Thank you and yes I started with a template from the start.



  • Scott Peters
    Scott Peters ✭✭✭✭✭

    Hello Jason - I think this would be fairly easy, to have a column in your inventory sheet that subtracts the count of requests for that clothing item from the available inventory, but you will need to think through how you want it to behave when you replenish the inventory. For example you may want to include dates and use a COUNTIFS formula. Have a date in the inventory sheet indicating when you last replenished that stock, and then only count requests where the date of the request is greater than the last inventory replenishment date.

    Hoping this helps,


  • Scott,

    Thank you for your answer above. So in our situation we will have an initial inventory for a campaign (4 years). Then we give our team apparel. Each time we give the apparel out we want it to use a form to basically account for who requested the apparel and what item by size and quatity they requested. This form should write to a sheet and then we want the formula on the main inventory sheet to deduct each request so that the inventory is updated. There will be no replinishing of stock along the way. When we have a new campaign, my plan was to create a new workspace and duplicate the sheets and rename it to the new campaign and then adjust the starting inventory accordingly. Does this make sense?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!