---
title: "And"
slug: "and"
updated: 2023-08-02T09:50:28Z
published: 2023-08-02T09:50:28Z
canonical: "docs.avontus.com/and"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# And

The **And** formula is a true or false formula that will display results if **all of** the set conditions are met. This will display data that matches the specified formula. For instance, you can use the **Filter** **Editor** to display results where the status is equal to **Initial Approval** AND the assignee is a specific user (e.g. Christian North).

To do this click **And** to select the **And** group and click the + icon.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/be3b3a12-8b59-491c-9353-a19e740718ce.png)

This will reveal three boxes, one red, one green, and one grey where you can specify the conditional formula.

The red button is where the column to be filtered is selected. This means the **Status** column will be filtered.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/27919937-e463-41f8-a60d-814561df0193.png)

The green button specifies the criteria to meet (e.g. Equals). This means that the content in the **Status** column must be exactly equal to the specified value (set in the next step).

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4a564eeb-f3a4-4cef-81af-6e9f976f88d5.png)

The grey button is for the value that the selected criteria must meet. Use the drop-down to select a value. In this example, we will select **Awaiting Build**

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/e171a956-0aa3-462a-8ad4-d37dde0b927e.png)

Next, click the + button to add another formula.

Select the red **Status** button and select **Assigned** **to**. This means that the filtered column will be the **Assigned to** column.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/4bc0681d-d62a-4cef-8398-1fd6ab2a5643.png)

Select the green button and select **Equals**. This means that the content in the **Assigned** **To** column must be exactly equal to the specified value (set in the next step).

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/6df0c5ea-0cc0-4be1-b619-b1b020e2e9b7.png)

In the **Value** field, select the name of the user. Selecting the name will mean only requests that are assigned to the selected user will be displayed.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/595bcbb8-9f0e-4bf5-9f0a-4df73f1c97dc.png)

Click **Apply** and **OK** to display all results that match the specified conditions. These conditions are:

- **Status** equal to **Awaiting Build**
- **Assigned to** equal to **Dave Franco**

**![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/516d0fdf-0373-43d3-986b-ca15e200542e.png)**

This will display the following content in the table.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/8bcead65-43bb-4de1-abc8-fe307a3ae969.png)