Skip to content
Tutorials
Share
Explore

Searching in lists

Some extended explanation and use cases about In() and Contains*()

(OR)

What

Searches for a
single value
in a list of items.

Use-case

Archive all tasks that are not open.
Create a new button that add a new row in the
table if the task is in a set of predefined statuses and removes them from the
table
Current
4
Task
Status
1
Strategy Plan
To Do
2
Call Customer
In Progress
3
Hire Sales Manager
In Progress
4
Trip to Mars
Won't Do
5
Trip to the Moon
Done
There are no rows in this table
Archive Tasks
Undo
Archived
1
Task
Status
There are no rows in this table

Formula

Formula (explained)

(OR)

(AND)

(AND and only...)

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.