Need assistance with building out a task
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
Comments
-
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")
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives