Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Counting rows with multiple drop-down options

Colin Entrekin
Colin Entrekin ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

Hello,

 

I would like to count all the rows on a sheet that meets certain criteria.  The sheet has a column [Project Status] with the following drop down items:

 

Tentative

Confirmed

In Process

Delayed

On Hold

Punch List

Completed

Cancelled

RMA Processing

 

I would like to get a total count of all the rows that have open projects, which would be one of the these statuses:

 

Tentative

Confirmed

In Process

Delayed

On Hold

Punch List

 

Please advise on how to make this formula work.  Thanks!

Tags:

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    Try this countif formula...

     

    =CountIF([Project Status]:Project Staus],"Tentative") + CountIF([Project Status]:Project Staus],"Confirmed") + CountIF([Project Status]:Project Staus],"In Process")

    CountIF([Project Status]:Project Staus],"Delayed" )+  CountIF([Project Status]:Project Staus],"On Hold") + CountIF([Project Status]:Project Staus],"Punch List" )

This discussion has been closed.