Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 10, 2022 02:52 AM
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!
Solved! Go to Solution.
Jun 10, 2022 03:14 AM
If you change the names of the fields, the formula will automatically change to reflect the new names.
Jun 10, 2022 03:14 AM
If you change the names of the fields, the formula will automatically change to reflect the new names.
Jun 10, 2022 06:02 AM
Ahhhhh! Ok, that’s great, thanks!
Jun 10, 2022 06:12 AM
@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)
Jun 10, 2022 11:03 AM
Additionally, SUM(Task1, Task 2)
would work, too since checkboxes look like 1s and 0s (boolean values) under the hood.