Can you use a COUNTIF formula to county symbols?

Stephanie D
Stephanie D ✭✭
edited 06/26/23 in Formulas and Functions

I have a list of goals for the year and we are using harvey ball symbols to indicate the percent complete an the red, yellow, green, gray balls to indicate the health/status of the project. I would like to display a report on my dashboard that shows the number of projects we have in each harvey ball stage and also in each status.


=countif=([% Complete]:[% Complete],"half")

I have tried a few different things but am getting unparseable.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!