# Checkmark Column Formula

Options

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)

Tags:

• ✭✭✭✭✭✭
Options

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.

• Options

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

• ✭✭✭✭✭✭
edited 07/27/21
Options

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

• ✭✭✭✭✭✭
edited 07/27/21
Options

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.

• Options

That was the key Andree, Thank you!

• ✭✭✭✭✭✭
Options

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.

• Options

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?

• ✭✭✭✭✭✭
Options

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)

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!