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

Thanks,

Jason

Find more posts tagged with

Formulas

Accepted answers

All comments

Naeem Ejaz

Yes contact me on my number 00923455332351 or email me at naeemejaz@hotmail.com

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!

Best,

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!

Jason Mobley

https://community.smartsheet.com/discussion/comment/337367#Comment_337367

Andree,

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

Thanks,

Jason

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

Jason Mobley

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.