Compare Qty's in different sheets

I have 2 sheets. One is Contract Requirements and one is Hardware Deliverables. I want to compare the Quantities on the Contract Requirements to the Quantities on the Hardware Deliverables.

For Example..

Contract Requirements list Qty 6 on one line

Hardware Deliverables lists, 1, 3, 2 on 3 lines

How do I sum the quantities in Hardware deliverables to compare to the contract requirement quantities?

Find more posts tagged with

Accepted answers

Jenn123

They are all calculation type formulas, I will try INDEX/MATCH and VLOOKUP. Thanks for the suggestion

All comments

Louis1

Hi J,

Is this what you are after? In the example below I am adding rows in sheet 2 and bringing them in sheet 1 using SUM via referencing another sheet (sheet 2) column.

Paul Newcome

I am leaning towards a SUMIFS. Are you able to provide some screenshots for reference?

Jenn123

I've been using SUMIFs and referencing the other sheet, then I ran into this error message. I have a lot of rows on my sheets. How do I do it differently so I don't get this message?

Smartsheet Image.png

Paul Newcome

There are a number of posts here in the community that have a lot of detail, but the general idea is that (when possible) you combine some of the columns you are referencing into a string, bring that string over as a single cross sheet reference, then parse the string out into multiple columns on the target sheet. I remember going through these steps on another thread not too long ago.

Do you have any that are just bringing across data such as INDEX/MATCH or VLOOKUP, or are they all calculation type formulas?

Jenn123

They are all calculation type formulas, I will try INDEX/MATCH and VLOOKUP. Thanks for the suggestion

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.