Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Count IF multiple criteria

Helene Delgado

Helene Delgado ✭

09/22/16 edited 12/09/19 in Archived 2016 Posts

Hi -

I would like to have a formula to count items based on a couple of criteria - Status and Deliverable.

I have attached a picture of the columns.

Formula Help.png

0 ·

Comments

Helene Delgado ✭

09/22/16

Nevermind. I found the answer. I need to use COUNTIFS. Haha...i love it when I answer my own questions.

0 · Share on Facebook Share on Twitter
Tim Meeks ✭✭✭✭✭✭

09/22/16

Hey Helene,

You need to use COUNTIFS......

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day