Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Better way to count no. of checkboxes

Topic Labels: Formulas
Solved
Jump to Solution
319 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m relatively new to Airtable, so I have a question if something I’m doing can be improved:

I have a base where I am counting the number of checked boxes (so far so good)
image

However, I will create a large number of bases where the task name varies and won’t be a simple Task1 etc.

Is there a way to count the no. of checked boxes without referencing the Task1, but something along the lines of referencing the cells (like in excel)

This way I can just duplicate the base and change the “task” name for each base as needed, without needing to change the formula all the time. But the formula would work regardless of what the task name is.

image

Thanks!

1 Solution

Accepted Solutions

If you change the names of the fields, the formula will automatically change to reflect the new names.

See Solution in Thread

4 Replies 4

If you change the names of the fields, the formula will automatically change to reflect the new names.

Ahhhhh! Ok, that’s great, thanks!

@Dave.k16 - for a slight more concise formula, you can use COUNTA():

COUNTA(Task1, Task2)

COUNTA counts the number of non-empty values (with checked being non-empty and unchecked being empty)

Additionally, SUM(Task1, Task 2) would work, too since checkboxes look like 1s and 0s (boolean values) under the hood.