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.

COUNTIFS on the same column

Options
Sean Flynn
Sean Flynn ✭✭
edited 12/09/19 in Archived 2016 Posts

Hi,

 

I'm trying to create a formula, which runs a count on a particular column

 

e.g. 'Status' column, with values of 'In Progress', 'Build' and 'QA'. I would like to find the total number of projects that have a status of:

 

'In Progress' and 'Build' 

 

I'm using the COUNTIFS formula, however no luck so far.

 

Any ideas would be greatly appreciated?

Comments

This discussion has been closed.