How to count multiple values in the same column
Background info :
- Product name is MR/HV13
- This product has 4 types (MR/HV1375, MR/HV1385, MR/HV1395 and MR/HV13115)
- I would like to count how many entries of each of the product types were submitted and total them under the mother product name which MR/HV13
- Initially, im using COUNTIFS and planning to do a monthly data presentation
- Can anyone kindly review my formula and advise the mistake/s?
Thanks much in advance…
Best Answer
-
Instead of listing each product as a separate requirement to the formula change that part of your formula to an OR formula
{MXR Pre-Delivery Inspection (PDI) Product},Or(@cell="MR/HVT 1375",@cell="MR/HV 1385",@cell="MR/HV 1395",@cell="MR/HV 13115"))
Answers
-
Instead of listing each product as a separate requirement to the formula change that part of your formula to an OR formula
{MXR Pre-Delivery Inspection (PDI) Product},Or(@cell="MR/HVT 1375",@cell="MR/HV 1385",@cell="MR/HV 1395",@cell="MR/HV 13115"))
-
@Hollie Green You just made my day! Your formula worked! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!