Summary Count by Assigned To and Status

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!