Count
Share
Explore
Count

icon picker
Count

⁠
⁠
⁠
Formula: Count()
Category: Collections
abacus.svg
⁠
⁠
Count()
Counts the size of a list
Or, put otherwise...
Hey Coda, can you count the size of this list?

Count() only uses one parameter:
ingredients-list (3).svg
⁠
⁠
List

Count(List)

The list you wanted counted. This list can be a table, column, or created set of values.

⁠
⁠
⁠
Count() simply counts the items in a list. If you need a refresher on what lists are in Coda, head to the
Lists
⁠
page.
While a simple formula, you will find yourself using Count() more than most formulas in Coda, especially when disabling buttons or automations. Before we get into actual use-cases though, let’s just learn how it works.

How To Use

A sentence is actually a list of words and Count() simply counts how many items are in the list. Type any sentence into the gray box below and watch how each word is counted.
1
This is a sentence and count() will be used to count the words in this sentence
There are 16 words in your sentence
There are no rows in this table
⁠

Going a Bit Deeper

We can also use Count() to find the answers to questions of quantity. Similar to the
Unique & Duplicates
⁠
lesson, the answers to each an every question below about the
People Database
⁠
would not be possible without Count().
How many different aged individuals are there?
​
⁠
⁠
⁠
​
⁠
⁠
How many unique favorite animals are there?
​
⁠
⁠
⁠
​
⁠
⁠

How many different birthdays will be have to celebrate?
​
⁠
⁠
⁠
​
⁠
⁠

How many different email domains do people have?
​
⁠
⁠
⁠
​
⁠
⁠


⁠
⁠
⁠
Done
Disable a button so it can only be pressed once each day
Done
Stop an automation from running if someone has completed all their tasks
Done
⁠

Gallery
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.