Need assistance with the following COUNTIFS formula
I am trying to count a status in one column (Last minute shipment set up) across MULTIPLE people in another column (Director). I created a working formula but it only tallies the status in one column across ONE person in another column:
=COUNTIFS([Director]:[Director], "john.smith@help.com", [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")
How can I modify this formula to add an additional person as criteria for Director?
Cheers,
Kristine
Best Answer
-
Hey @Kristine Gagne, CSM, CSSGB !
Does this solve the problem for you?:
=COUNTIFS([Director]:[Director], OR(@cell="john.smith@help.com", @cell= "INSERT ANOTHER NAME HERE"), [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")
If not, let me know & explain a little more - I'd love to try and help!
-Jon Mark
Answers
-
Hey @Kristine Gagne, CSM, CSSGB !
Does this solve the problem for you?:
=COUNTIFS([Director]:[Director], OR(@cell="john.smith@help.com", @cell= "INSERT ANOTHER NAME HERE"), [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")
If not, let me know & explain a little more - I'd love to try and help!
-Jon Mark
-
Hi Jon -
This worked perfectly! I had tried something similar but had my parenthesis for the first range in the wrong spots. Thank you very much!
Cheers,
Kristine
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!