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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives