Need assistance with building out a task
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.
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,
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