Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi, can someone please help me - I am trying to count the total of Red, Yellow and Green Balls in a column and cant get my formula to work. Currently my formula reads
=COUNTIFS([Status2]4:[Status2]33, "GREEN", "YELLOW", "RED")
thank you
Very close! try something like this...
=COUNTIFS([Status2]4:[Status2]33, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))
Hi Chris,
Try this.
=COUNTIF([Status2]4:[Status2]33; "GREEN") + COUNTIF([Status2]4:[Status2]33; "YELLOW") + COUNTIF([Status2]4:[Status2]33; "RED")
The same version but with the below changes for your and others convenience.
=COUNTIF([Status2]4:[Status2]33, "GREEN") + COUNTIF([Status2]4:[Status2]33, "YELLOW") + COUNTIF([Status2]4:[Status2]33, "RED")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Thank You Paul, It worked - Much Appreciated!
Thanks Andrea, appreciate the help - Tried Both you and Pauls, both worked. Thanks heaps
Happy to help.
Looks like Andree and I were typing up solutions at about the same time. Hahaha
Happy to help!
Andrée
I want to do the same thing but I couldn't get the formulas to work. I'm in the States. Can you send me a formula suggestion for this:
@Susie Wachowski
My formula above should work for you. What exactly are you trying to accomplish and what results are you getting?
I'm trying to count the number of green, yellow, and red balls in the Status column. I'm getting a #UNPARSEABLE error message. This is the formula I modified to count rows 3-142 in the Status column: =COUNTIFS([Status1]3:[Status1]142, OR(@cell = "Red", @cell = "Yellow", @cell = "Green"))
What is your actual column name?
Status
Try using your actual column name instead of [Status1]. That should clear it up for you.
Ahh yes, that was the secret, thank you!!
Happy to help! 👍️
Is there a way to revert to the old dashboard look and feel. The new dashboards do not look good at all. There is no way of knowing if there are additional items in the widgets until you scroll over one to learn there is more to it since the vertical bar doesn't show. We have hundreds of dashboards and they will all need…
When i try to send or print the timeline view instead of showing the progression bars like they do on the screen it only send the data entered and not a graph type view to print. Is there a way to do this. I am using a mac platform if that helps.
Please assist me, I am having trouble with my smartsheet, I am on a paid pro plan, with 5 paid members, but neither I or my members can access or edit sheets. When I try to share the sheet, it says that I only have viewer access. My team members cant access the sheets at all. I renewed my subscription recently and it seems…
