Checkmark Column Formula

Kyle Braude

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)

Andrée Starå

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!

Kyle Braude

It did not, It popped up with a boolean expected error

Bassam Khalil

@KBraude

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:

Andrée Starå

@KBraude

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?

Kyle Braude

That was the key Andree, Thank you!

Andrée Starå

@KBraude

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!

Kyle Braude

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?

Andrée Starå

@Kyle Braude

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?