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

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



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?


This discussion has been closed.