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 https://community.smartsheet.com/discussion/6552/countif-rows-meets-multiple-criteria.
=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!
Thanks!