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

Weighted Check box's
Just looking to see if there a is a better way to do this. i know i can Write a LONG IF statement to do this. i would like if Step 1 is Check Step Percent would %20 If Step 1 and Step 2 is Checked it would = 75 % if Step 1,2,3 are Checked it would = 95% if step 1,2,3,4 are Checked it would = 100% just looking to see if…
Making a new sheet after the most recent update
I used to be able to make a sheet in my own file (see img) using the Create button in the top right corner. Now I can't make a new sheet without creating a workspace around it. How do I make it not do that anymore? I just want to make a sheet for my own use and keep it in the file with all the others I'm currently using,…
Help with "INDEX MATCH"
Hello, I'm kind of new to Smartsheet and I've been tasked with transitioning a lot of data into Smartsheets, with that said - I have a data sheet that I need to INDEX MATCH actuals into a forecast sheet. Whenever I try to enter an INDEX MATCH formula, it keeps saying that multiple criteria is not supported or the MATCH…