Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Count "green balls" within a range

Zoe McInerney

Zoe McInerney ✭

03/06/17 edited 12/09/19 in Archived 2017 Posts

Hello

I'm am wanting to count "green balls" within a range. I have used

=COUNTIF([Site Attended]11:[Site Attended]26), "green")

I'm have the result #unparsable

I am a new user so would apprecate the help. Thank you

Tags:

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

03/06/17

You have one too many close paranthesis.
Try this instead

=COUNTIF([Site Attended]11:[Site Attended]26, "green")

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…
Approval Request - link expatriation
Hi, I'm in the process of setting up a system for gathering approvals and I'm curious to know if the approval link included in the automated email has a set expiration date or if approvers have the flexibility to access the link at any time to cast their vote.