Welcome!

Countif based on multiple criteria

Sarah McMorrow

I have two columns, assignee and status, that I am trying to use the Countif option on.

I would like to count based on a specific assignee and specific statuses.

If Assignee = A and (status = B or C), then count.

Find more posts tagged with

Comments

Paul Newcome

Try something like this...

=COUNTIFS(Assignee:Assignee, "A", Status:Status, OR(@cell = "B", @cell = "C"))

Sarah McMorrow

I attempted to use this query but am getting an #UNPARSABLE error.

=COUNTIFS(Assignee:Assignee, "Sarah McMorrow", Status:Status, OR(@cell = “Completed", @cell = “Completed - Bug Found"))

Screen Shot 2019-04-17 at 12.52.46 PM.png

Paul Newcome

I can't remember the exact names for the different types of quotes (smart quotes and not-smart quotes?). Either way... You have 2 different types of quotes in your formula. The oddballs out are the quotes immediately before each of the words Completed.

Try retyping it directly into Smartsheet. That should work for you.

Sarah McMorrow

You are amazing - thank you so much. I had been spinning my wheels for far too long!

Paul Newcome

Happy to help!

I usually build my formulas directly in Smartsheet, but I have seen suggested that if you are going to edit a formula (using find/replace for example), Word tends to put in the wrong quotes, but Notepad works when copy/pasting.

Sign in to join the conversation!

Quick Links

Trending discussions

Is it a bug? "Removing user Access" by clicking X - works sometime and then it does not.
Hi everyone, I'm the owner of worksheet/workspace and am currently unable to reliably remove user access through the "Manage Access" panel. This issue just started occurring recently. The Problem: When I click the "X" next to a user's name to remove them, it works for the first user. For any subsequent user, the "X"…
Can one cell change cause workflows in multiple grids?
I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1. Here is my setup and what the issue I'm having… Grid #1 has the column that is being updated. Workflow setup on Grid #1 to move the row when the cell is changed to a…
Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑