Need Formula for Subtracting Order Quantities from Inventory Quantities

Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet?

I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for each item.

I have another sheet where we will manage the inventory of all items. Those items are listed out in one single column, with the quantities of each item in another column. Any help would be greatly appreciated!

Find more posts tagged with

Sheets

Formulas

Automations

Accepted answers

All comments

dsmith616

Sounds like you just need use subtraction formula. You'll need to do a cross sheet reference between the sheets/fields you're wanting to calculate. Just add an additional column, something like "Remaining Quantity" to track the calculated field

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.