How do I count how many projects are "In Progress" or "Completed" ?

courtney jones

HI There,

I feel this should be easy to figure out but i cant seem to! PLEASE HELP?!

I have a column called "STATUS" , I have a drop down menu with the following under Status

STAUS

On Hold

In Progress

Cancelled

Completed

How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled"

Ideally this will pull through onto a dashboard showing the below data

EG:

2 "on Hold"

10 "Completed"

35 " In Progress"

Find more posts tagged with

Formulas

Sheet Summary

Project Management

Accepted answers

All comments

Bassam Khalil

Hi @courtney jones

Hope you are fine, please try the following formula:

=COUNTIFS(STATUS:STATUS, CRITERIA@row)

and in the dashboard add chart and select the data range using the table shown in the following screenshot:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.