Count

Share

Explore

Count

Count

⁠

⁠

⁠

Formula: Count()

Category: Collections

⁠

⁠

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?

⁠

⁠

⁠

⁠

⁠

⁠

⁠

⁠

Practice: Find the number of rows in a table

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

⁠

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.