> For the complete documentation index, see [llms.txt](https://help.3sigmacrm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.3sigmacrm.com/features/pipelines.md).

# Pipelines

Track deals, projects, bookings, site visits or anything else with your own custom pipelines in 3sigma CRM

A **pipeline** is your own list for anything you track — **deals, projects, site visits, orders, bookings** and more. You choose the fields (columns) and the stages, add records, move them stage by stage, and link them to your leads and to other pipelines. 🚀

{% hint style="info" %}
Pipelines is in **Beta**. Open it from the sidebar under **More > Pipelines**.
{% endhint %}

***

## **How Pipelines Work**

1. **Make a pipeline** and pick its fields 🛠️
2. **Add records** and move them stage by stage ➡️
3. **Link records** to leads and to other pipelines 🔗

The first time you open Pipelines, a short **Tour** walks you through the page. You can replay it any time with the **Tour** button.

***

## **Create a Pipeline** ➕

Click **New Pipeline** at the top of the page. Creating a pipeline takes three steps: **1. Template → 2. Basics → 3. Fields**.

### Step 1: Pick a starting point

* **Build with AI** ✨ — Tell it how your work runs in a chat. It sets up the stages, fields and links — even a few linked pipelines at once (see below).
* **Start blank** — An empty pipeline. Add your own fields from scratch.
* **Templates** — Start with fields and stages already set up, such as **Sales Deals**, **Project Tasks**, **Hiring Pipeline**, **Bookings**, **Support Tickets**, **Site Visits**, **Payments**, **Real Estate**, **Admissions**, **Loan Applications**, **Stock / Inventory** and more.
  * Templates that suit your type of business are shown first under **For your business**. The rest are under **All templates**.

### Step 2: Basics

* **Pipeline Name** — e.g. Deals, Projects, Bookings.
* **Description** — what the pipeline is for (optional).
* **Icon** — pick an icon for the pipeline tab.
* **What can this connect to?** — pick what each record can link to: **Leads**, **Tasks**, **Quotations**, **Orders**, **Invoices** or your other pipelines. For each link, choose **One per record** or **Multiple allowed**. You can change this later.

### Step 3: Fields

Add the fields your records need. A pipeline needs at least one field before it can be created. See [Fields](#fields) below.

### Build with AI ✨

1. Click **Build with AI** (on the New Pipeline screen or at the top of the Pipelines page).
2. Describe your work in the chat. Tap the suggested answers or type your own.
3. The AI works in three stages:
   * **Understand** — it maps how your work runs, step by step, so you can check it.
   * **Build** — it sets up the stages, fields and links. Several pipelines can be built at the same time.
   * **Review & create** — change anything you like: pipeline name, stages, fields, and options such as **Only one open at a time**. Nothing is saved until you tap **Use this pipeline** (or **Create all … pipelines** when it built several).

***

## **Fields** 🗂️

Fields define what each record holds. Admins manage fields in the pipeline's **Settings** tab. Click **Add field**, choose **What kind of field?**, and give it a **Field name**.

**Field types:**

* **Text**, **Name**, **Email** (click to send), **Phone** (click to call), **URL**
* **Number**, **Amount** (shown with ₹), **Quantity (±)** (count with + and − buttons)
* **Date**, **Time**
* **Dropdown** (pick one) and **Multi-select** (pick many)
* **User** — a team member
* **Product** — pick from your products
* **Location** — address or map pin
* **Attachment** — upload a file
* **Group** — a set of fields you can repeat (e.g. several items in one record)
* **ID** — an automatic number like DEAL-12
* **Calculated** — a number worked out from other fields (see below)

**Field options:**

* **Must be filled in** — makes the field required.
* **Default value** — pre-filled on every new record. For dates and times you can choose **Today (the day it's created)** / **Now (the time it's created)**, or a fixed date or time.
* **Show only when another field matches** — show the field only when another field meets a condition (e.g. show "Reason lost" only when Status is equal to Lost).
* **Who can see and edit this** — for each role (**Admin**, **Team Leader**, **Employee**) choose **Can see** and **Can edit**.
* **Choices** (Dropdown / Multi-select) — type a choice and press Enter. Turn on **Mark which choices mean Won or Lost** to tag stages as Open, Won or Lost.
* **Kanban card** — tick a field to show it on Kanban cards.

### Calculated fields (AUTO) 🧮

A **Calculated** field works out its value for you. In records it is shown with an **AUTO** tag and can't be typed into.

When you add one, write a **Formula** — click a field or a linked pipeline below the box to add it. The formula is checked as you type and shows **Formula works** with a preview.

* **{field}** — the value of another field on the same record, e.g. `{Price} * {Quantity}`
* **sum(pipeline.field)** — add up a field across linked records (e.g. total of all linked payments)
* **count(pipeline)** — how many records are linked
* **sumif(...)** / **countif(...)** — add up or count only linked records with a certain status (e.g. only "Paid")

{% hint style="info" %}
Only Number, Amount, Quantity and other Calculated fields can be used in a formula.
{% endhint %}

***

## **Working with Records** 📋

Each tab at the top is one pipeline. Click a tab to open it. Pin a pipeline to keep it first in the list.

Inside a pipeline you'll find:

* **Records** — every entry in this pipeline
* **Reports** — count and add up your records
* **Automations** — do things when a record changes *(admins only)*
* **Settings** — fields, links, roll-ups and who can see it *(admins only)*

### Add records

* Click **Add** to open a quick form and create a new record.
* Click **Import** to add many records from a CSV file:
  1. **Upload file** — click **Download template** to get a file with one column per field and the allowed choices.
  2. **Match columns** — match each column to a field, or **Skip this column**.
  3. **Import** — rows with problems are listed under **Rows to fix**. Fix them in your file and **Upload a fixed file**.
* Pipelines with an **ID** field number records automatically (e.g. INV-2026-001).

### Views 👀

Switch between three views:

* **List** — a spreadsheet-style table. Click a cell to edit it directly. Use the column menu to **Sort ascending**, **Sort descending**, **Filter** or **Hide column**. Drag columns to reorder them, and use **Add column** to create a new field right from the table.
* **Kanban** — a board with one column per stage. Use **Group by** to choose the field, and drag cards between columns to move a record.
* **Date** — records laid out by a date field, by **Day** or **Week**. (Shown only when the pipeline has a date field.)

### Search, filters and saved views 🔍

* **Search records** to find a record quickly.
* **Add filter** to narrow down the list. Toggle between matching all or any of your filters.
* **Show totals** to see the **Sum**, **Average**, **Minimum** or **Maximum** of a number field for the filtered records.
* **Save view** to keep a set of filters (e.g. "At-risk this week"). Open it later from **Saved views**.

### Bulk actions

Select records with the checkboxes to:

* Change the status or set the owner for all of them
* **Link to a record in…** another pipeline
* **Send WhatsApp** using a template
* **Delete** *(admins only)*

***

## **Record Details** 🔎

Click any record to open it as a full page. Use the arrows (or **↑ / ↓** keys) to move to the previous or next record.

* **Overview** — all the record's fields. Edit them in place.
* **Record score** — a score out of 100 based on fields filled, stage progress and linked records, with a **Next step** tip.
* **Activity** — a timeline of changes, plus **Comments** and **Files** for your team.
* **Leads** — leads linked to this record (when the pipeline connects to Leads).
* **Linked pipeline tabs** — one tab per linked pipeline or CRM module (Quotations, Orders, Invoices). From a linked tab you can **Add**, **Import**, **Bulk add** / **Add existing** records, or **Unlink** them.
* Quick actions to **Call**, **WhatsApp** or **Email**.
* A meeting-link field can create a Google Meet for the record's date and time with **Create Google Meet**.

***

## **Reports** 📊

Open the **Reports** tab and **Build a report**:

* **Group by** a field (e.g. Stage, Owner, Product) and optionally **Split by** another.
* **What to show** — **How many records**, **Total of a field**, **Average of a field**, **Highest value** or **Lowest value**.
* **Period** — **Today**, **This week**, **This month**, **Last month**, **This year** or **Pick dates**.
* **Chart** — **Bar**, **Pie** or **Table**.

Name it and click **Save report**. Saved reports appear under **Saved reports**.

***

## **Pipeline Automations** ⚡ *(admins only)*

Open the **Automations** tab and click **Create automation**.

* **When** — **A record is added**, **A record changes**, **One field changes**, or **A date comes** (e.g. 1 day before a session; checked once a day at 9 AM).
* **Only if** — optional conditions. Leave empty to run every time.
* **Then** — one or more actions, run in order:
  * **Set a field** / **Clear a field** / **Change the status**
  * **Assign to a teammate**
  * **Move to another pipeline** / **Copy to another pipeline**
  * **Send a WhatsApp message** / **Send an email** (to the record, or to every linked record)
  * **Create a task** / **Add a note**

***

## **Pipeline Settings** ⚙️ *(admins only)*

* **Pipeline name** — rename the pipeline.
* **Pin** — show this pipeline first in the tabs.
* **Share pipeline** — only people added here (and the owner) can open the pipeline. What each person can do follows their role.
* **Auto-number records** — set the **Prefix** (e.g. INV-2026-) and **Start from** number.
* **Linking** — connect or disconnect other pipelines, choose one or many linked records per record, and turn on **Show its activity here** to see a linked pipeline's notes, calls and changes in this record's Activity tab. You can also allow **the same lead more than once**, or **Add every new CRM invoice / order here** automatically.
* **Update from linked records** — add up linked records (like payments) and update this record's status, total or paid date by itself.
* **Fill links automatically** — when you pick one record, fill in its other links for you (e.g. pick an instalment → its invoice is filled in).
* **Fields** — add, edit, reorder or remove fields.
* **Duplicate pipeline** — creates a new pipeline with the same fields, numbering, sharing and CRM connections, but no records.
* **Delete pipeline** — removes the pipeline and all its records. This can't be undone.

***

## **On the Mobile App** 📱

Your pipelines are also on the mobile app: tap **More** > **Pipelines** and pick a pipeline. You can:

* Switch between list and board view, use the quick filters (**Mine**, **Unassigned**, **Stale**, **Day view**) and use **Saved views** from the web.
* Tap **+** to add a record, or **Import CSV file**.
* Open a record to see its **Overview** and **Activity**, **Call**, **WhatsApp** or **Email** the contact, **Edit all fields**, **Create Meet link** or **Link a related record**.
* **Long-press** a record to select several and change status, assign, send WhatsApp or delete them.

See [Using 3Sigma on mobile](https://help.3sigmacrm.com/features/mobile-app.md#pipelines) for details.

{% hint style="info" %}
Creating and designing pipelines (fields, stages, calculated fields), **Reports**, **Pipeline Automations** and **Pipeline Settings** are only on the web app.
{% endhint %}

***

## **Tips** 💡

* Start from a template or **Build with AI** — you can change every field and stage later.
* Use a **Calculated** field to show totals like "Balance due" without any manual maths.
* Link a pipeline to **Leads** so your team can see every deal, visit or booking for a lead in one place.
