Add Package Count Based on Customer

I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday.

I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package count for Monday.

Find more posts tagged with

Sheets

Formulas

Reports

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/142297/add-package-count-based-on-customer

Hi,

I hope you're well and safe!

If possible, please share some screenshots and/or additional information. (Delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Melanie Auran

I actually was able to get the formula down for a sheet, but my next question is I have this formula but I want it to add from another sheet and put the total on a new sheet. So, how do I get this to add the information from Sheet One and put it on Sheet Two

=SUMIF(Customer:Customer, CONTAINS("Customer", @cell ), Monday:Monday)

Paul Newcome

You would use {Cross Sheet References}. The below article should help you get started:

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Andrée Starå

Excellent!

You can either use one or a combination of the following.

1️⃣ Cell linking: https://help.smartsheet.com/learning-track/level-2-intermediate-users/cell-linking

2️⃣ Cross-sheet formulas: https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Make sense?

Would that work/help?

✅ Remember! Did I help answer your questions or solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. It will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Melanie Auran

I've messed around with it and I'm still not getting it to do what I need.

The sheet this information is on is called Weekly Pallet Count and I've tried this formula, but I'm missing something it isn't counting, just saying it's unparseable.

=SUMIF({Weekly Pallet Sheet}, [Customer:Customer], CONTAINS("Expeditors", @cell ), [9/15]:[9/15])

Paul Newcome

@Melanie Auran Each range would be a separate cross sheet refernece.

=SUMIF({Weekly Sheet Customer Column}, CONTAINS("Expeditors", @cell), {Weekly Sheet 9/15 Column})

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.