Need assistance with building out a task

bjagasia
bjagasia
edited 12/09/19 in Smartsheet Basics

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

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

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com