Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Better way to count no. of checkboxes

Topic Labels: Formulas
Solved
Jump to Solution
2156 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Dave_k16
4 - Data Explorer
4 - Data Explorer

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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.