Count of requests with team member with specific request statuses


sharing below sample data wherein one column I have list of team members and other columns I have status of the requests . Can someone help with formula to find the count of all the requests with Alice having status either In progress and Delayed. I dont want to count Cancelled count.

Resource Request Status

Alice In progress

Alice In progress

joe Cancelled

Tom In progress

Alice Cancelled

Alice Delayed

Alice Delayed


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Shikha Kapoor 3,

    You have a few options.

    Counting those 2 specific choices (In Progress or Delayed):

    =COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], OR(@cell = "In Progress", @cell = "Delayed"))

    Counting everything that isn't cancelled:

    =COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], <>"Cancelled")

    Or as an alternative if you need the details just at a glance, you could also use a report.

    Hope this helps, but if you've any problems/questions then just let us know!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!