Checkmark Column Formula
Afternoon,
I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them?
This is the formula I am trying to make work- =COUNTIFS([Construction Complete- Not Submitted]2:[Construction Complete- Not Submitted]254, 1)
Answers
-
Hi @KBraude
I hope you're well and safe!
Try something like this.
=COUNTIF([Construction Complete- Not Submitted]2: [Construction Complete- Not Submitted]254, 1)
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It did not, It popped up with a boolean expected error
-
Hope you are fine, as i see in your screenshot you are traying to count the checkbox for chilled rows and you write the formula in the parent row. if this what you are doing then you will get the following error:
#BOOLEAN EXPECTED
Cause
The formula is in a specific type of column (Date, Number, Symbol) and the returned value is of a different type.
Resolution
Either move the formula to a different column, or convert the result to the appropriate type. Formula results may be converted to text values by adding an empty string. For example =TODAY() + "" will allow you to enter today's date into a text column.
so use the following formula to do the counting in the parent row:
=COUNTIFS(CHILDREN(), @cell = 1) + ""
the following screenshot shows the result:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Yes, I missed that you have to add +"" after the formula.
=COUNTIF([Construction Complete- Not Submitted]2: [Construction Complete- Not Submitted]254, 1)+""
Did that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That was the key Andree, Thank you!
-
Excellent!
Happy to help!
✅Remember! 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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Secondary question- Something i am not familiar with or if it is even possible within this program. Is there an automation setting to put checked boxes to the top of the sheet. EX: if a box becomes checked in a certain column it moves to the top of that column?
-
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
Here's a possible workaround or workarounds
- Sort the sheet (manual)
- Use a report instead
Would that work/help?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!