What is the formula to calculate number of projects by status?

Nascie1

I tried the count functions but the only return the total number of status not the # of projects. Blue=In Progress and Green =Complete.

jmyzk_cloudsmart_jp

Hi @Nascie1

You can use the COUNTIFS function like this;

=COUNTIFS(Level:Level, 1, Status:Status, Status#)

As for the Project's Status, I assumed it takes the worst.

https://app.smartsheet.com/b/publish?EQBCT=0fb756487a1c46efb64bd5590fe2c21b (Link to the demo sheet. You can change the Status in Sheet Summary to see how the formula works.)

Nascie1

It still says unparseable. I am trying to aggregate the data for a dashboard. I also put the columns into a report and then added filter on level as being 1 but created a new column for status and wrote out (Complete, In Progress or Not Started). Which gave me the following: