Gallery
IsBlank & IsNotBlank
Share
Explore

icon picker
IsBlank & IsNotBlank

Formulas: IsBlank() and IsNotBlank()
Category: Info
unchecked-checkbox (1).svg

IsBlank()
Checks if a value is blank; returns True/False
or stated otherwise...
Hey Coda, can you tell me whether this spot in my table is blank?
checked-2.svg

IsNotBlank()
Checks if a value is not blank; returns True/False
put a bit simpler...
Hey Coda, can you tell me whether this spot in my table is not blank?

IsBlank() and IsNotBlank() both use only one parameter:
exposure-value (6).svg
Value

IsBlank(Value)

The value you want to check.

IsBlank() and IsNotBlank(). Both formulas, like the rest of the Info formulas, work by checking if a piece of information—a value, an item in a list, etc.—is the type of information you’re looking for. On the face of it, this might sound confusing.
Its value is unlocked, however, as we begin to see just how checking types of information can make our documents more fluid.

Filters

Filtering through your data is one of the most common ways IsBlank() and IsNotBlank() are used.
Let’s say you’re managing our and want to see which items do or do not have an assigned ecosystem. Perhaps you want to know this information because, as the manager of a project, you want to have a list of what hasn’t been completed.
Click the toggle below to see which of the first 10 items from the list are “completed” and which are not:

See the blank entries
all entries

This is a list of the first 10 plants that do not have an assigned ecosystem.

Slender Oat
Narrow Leaved Clover
American Vetch
Yellow Bush lupine
Pacific Madrone
Arctic Butterbur
Western Maidenhair Fern
California Bay Laurel
Pacific Sanicle
Broad leaved Dock
Go into the filter options for this table to see how IsBlank() was used.

In this use case, using IsBlank() is like saying :
Hey Coda, take a look at these 10 trees. Will you show me the ones where the
Broken link
column is blank?

Conditional Buttons, Formatting, Etc.

Another common use for IsBlank() and IsNotBlank() is when you are need conditional formatting, column values, or buttons.
We used IsBlank() /IsNotBlank() three different times in the table below. Take some time to play with the table—press the buttons, assign/un-assign individuals. Can you guess where these formulas are used? After you’ve made your guesses, check the boxes below to reveal the answers:

Check box to reveal the answer!
Check box to reveal the answer!
Check box to reveal the answer!

Task
Assignee
Assign Task
1
Edit ForEach lesson
Assign Task to myself
2
Complete Email Drip Campaign
Assign Task to myself
3
Create voting table for course header design
Assign Task to myself
There are no rows in this table

Further Notes

A couple of the above examples can be completed without writing lengthy formulas. Behind the scenes, though, they are using the same formulas we just covered:


Done
Overwrite a formula column with an editable value
Done
Expand on Activity 1 by creating more variability in your button
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.