Summary Count by Assigned To and Status
Hello Smartsheet Community!
I hope everyone is doing well. I'm a bit of a newbie to what I consider more advanced formulas and need some help with a formula for the Summary section of a Smartsheet.
Essentially, what I need the formula to do is to count by Assigned To for any Task Names that are either Not Started OR In Progress.
I'm able to get the first part working where I get a count by Assigned To and one of the status indications. It's when I attempt to add BOTH status indications that things go #UNPARSEABLE on me.
Here's what I have so far:
=COUNTIFS([Assigned To]:[Assigned To], FIND("XYZ", @cell) > 0, Status:Status, <>"Not Started") which returns a count of tasks with a status of "Not Started" for the Assigned To of "XYZ" in this example.
How do I get it to OR the two statuses of "Not Started" OR "In Progress", so I just get a count of those two combined?
I hope this makes sense.
Thanks in advance for any help and enjoy the weekend ahead!
-Kurt
Answers
-
Try this:
=COUNTIFS([Assigned To]:[Assigned To], FIND("XYZ", @cell) > 0, Status:Status, OR(@cell = "Not Started", @cell = "In Progress"))
-
That works beautifully! Thank you so much! Simple enough but for some reason none of the "OR" statements I was trying worked.
I appreciate the help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!