Create a formula using the outcome of another formula in a different column

Yars

Basically, I want to know all the Issues for the 4 stars groups.

Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue])

But I want to say, all Colorado groups have (this amount of

Smartesheet.png

issues) which is the result of the previous formula.

Yars

I'm trying this but it is not working

=IF(State:State, "Colorado", COUNT([Issue]#))

Zachary Hall

If I understand you correctly, I believe this should do it:

• =COUNTIF(State:State, "Colorado")