Sign in to join the conversation:
Hello all,
I'm looking to count the number of "stars" within a column and have been testing with
=COUNTIF(check_column, "true"). This isn't working. Any ideas?
Hi Anthony,
You'll have to use "1" for true and "0" for false.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
You will also need square brackets [ ] around your column name.
I think you also need to complete the column range, right?
=COUNTIF([check_column]:[check_column], 1)
Thank you everyone. Counting "stars" did not work.
I've changed the column data type to numbers.
Great support reactions here!!!
Happy to help!
If you still want to use stars instead.
Try this.
=COUNTIF([Star Column]:[Star Column]; 1)
The same version but with the below changes for your and others convenience.
=COUNTIF([Star Column]:[Star Column], 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
I tried all possible trial and error, finally got my desired outcome with below. It counted exactly the number of stars in each of the columns in the range I provided.
((COUNTIF(Development1:Collaboration1, ="five") * 5) + (COUNTIF(Development1:Collaboration1, ="four") * 4) + (COUNTIF(Development1:Collaboration1, ="three") * 3) + (COUNTIF(Development1:Collaboration1, ="two") * 2) + (COUNTIF(Development1:Collaboration1, ="one") * 1))
Good Luck!!!
Hi @Anitha
I hope you're well and safe!
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
