Incomplete Tasks Count Multiple Criteria

I am trying to account for the number of incomplete tasks for Symbol column types.

For example, our 'On Target" column uses the RYG Balls, and i am trying to pull back the number of incomplete tasks based on their color (red, green or yellow). This is the formula i have tried to use based on recommendations from this post

=COUNTIFS([Checkbox Column]:[Checkbox Column], = "false", [On Target Incomplete]:[On Target Incomplete],"Green")

I am currently getting an #UNPARSEABLE error. Any help and advice on this would be greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!