Need assistance with building out a task

bjagasia

Hi,

I'm attempting to build out a overall project tracker (not based off an Gannt chart or anything). 

Essentially each project will have a set of deliverables that need to be tracked and ultimately pump out a chart at the end monitoring progress.

For example,

 

Project A Spreadsheet

Deliverable Name | Owner | Status 

Deliverable A | @Random | In Development 

Deliverable B | @Random2 | In Progress

Deliverable C | @Random3 | QA

Deliverable D | @Random4 | Complete

 

Now what I want to be able to do is is drive those Status values to numbers, for example,

 

Status 

In Development = 5%

In Progress = 40%

QA = 80%

Complete  = 100%

 

I'm trying to use the IF formula but it keeps coming out as #UNPARSEABLE. Ive tried it by linking different sheets, even having it on the same sheet but same problem. 

 

edit: i want to pull in percentages

Paul Newcome

First you need to know how many total deliverables you have...

 

=COUNT([Deliverable Name]:[Deliverable Name])

.

Then you need to count how many are in a specific status category.

 

=COUNTIFS(Status:Status, "In Development")

.

Divide the first number by the second and format the column as percentages, and there you have it.

=COUNT([Deliverable Name]:[Deliverable Name]) / COUNTIFS(Status:Status, "In Development")