Sum number of items based by Product Category selected
Hello:
I am creating a Purchase management based in the template loans.
I just use one sheet
_Small Business Request Intake Sheet
it has these columns
So in the sheet
📌 Purchases Metrics (Do Not Edit)
I am creating a column called "Total units" based in the purchase category that show me the number of units are requested by Category, for instance in the image above we have 3 Chromebooks "in Review" and 2 Chromebooks "not reviewed", So I would like that to sum both quantities based in the Category Chromebooks Quantities 5.
At this moment I am using this Formula.✎
=SUM({Small Business Request Intake Sheet quantity}, [Data Points]@row, {Small Business Request Intake Sheet Category}, [Data Points]@row)
I am totally blocked!!! 🙈
PD: if is not ask to much please could you help me too to show "Total units Not Reviewed" to show for instance 2 Chromebooks?
❤ Thank you so much 🙏
Best Answers
-
Just for those who need this formula also: Support helped me.
=SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Intake Sheet quantity})
how to add second criteria to the formula.
to sum the quantity based First in the IT category and also in the status of the requests I am trying this one.
=SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold", {Small Business Request Intake Sheet quantity}))
I need help to add a second condition by category and by review status...any Idea?
-
Ok, once again support helped me to find the solution:
=SUMIFS({Small Business Request Intake Sheet quantity},{Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold" )
thank you smartsheet support
Answers
-
Just for those who need this formula also: Support helped me.
=SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Intake Sheet quantity})
how to add second criteria to the formula.
to sum the quantity based First in the IT category and also in the status of the requests I am trying this one.
=SUMIF({Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold", {Small Business Request Intake Sheet quantity}))
I need help to add a second condition by category and by review status...any Idea?
-
Ok, once again support helped me to find the solution:
=SUMIFS({Small Business Request Intake Sheet quantity},{Small Business Request Intake Sheet Category}, [Data Points]@row, {Small Business Request Sheet Review Status}, "On Hold" )
thank you smartsheet support
-
......
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!