Skip to main content

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!

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

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


Ahhhhh! Ok, that’s great, thanks!

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.

Reply


Terms & Conditions