Need assistance with building out a task

edited 12/09/19 in Smartsheet Basics


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,



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
    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")