Can you use a COUNTIF formula to county symbols?

Options
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([Status]:[Status]),(["Green"])

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


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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!