Skip to main content
Solved

Better way to count no. of checkboxes

  • June 10, 2022
  • 4 replies
  • 144 views

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)

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.

Thanks!

Best answer by ScottWorld

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

4 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • June 10, 2022

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


  • Author
  • New Participant
  • June 10, 2022

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


Ahhhhh! Ok, that’s great, thanks!


JonathanBowen
Forum|alt.badge.img+18

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)


Kamille_Parks11
Forum|alt.badge.img+27

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