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.
How to count number of flags in column?

tobrien3
✭
What formula would I use to count the number of flags that are up in a column?
Tags:
Comments
-
Hi,
Here is what you are looking for :
=COUNTIF([Column15]3:[Column15]12, 1)
If you want to write the result in the same column, simply add + "" at the end to prevent errors...
(=COUNTIF([Column15]3:[Column15]12, 1)+"")
Hope that helps,
Étienne
-
Thanks!
-
tobrien3
To get all of them, you'll need to modify Etienne's formula a bit.
Hers shows only 10 rows.
=COUNTIF([Column15]:[Column15], 1)
will show the count of the whole column -- you'll just need to put it in a different column.
Craig
This discussion has been closed.