# AISUMMARIZE Function

The AISUMMARIZE function makes a short summary of text from one or more cells. The AI writes the summary. The function does not write the cell value during the calculation. The function collects its parameters and sends an AI event. The system writes the summary in the cell when it completes the event.

AISUMMARIZE is a SmartColumn AI function. Use it only as a column formula. Do not use it in a different function. Do not use it in a cell formula.

## Syntax

```
AISUMMARIZE(data, [additional_instructions])
```

- **data** The text to summarize. Use a cell reference, a range, or a LIST() of values. Use LIST() to put values from more than one column into one input.
- **additional_instructions** (optional) Text instructions for the AI. Examples: a length limit, a tone, or a subject to give attention to.


## Sample usage

```
AISUMMARIZE([Task Description]@row, "Keep under 100 characters")
```

```
AISUMMARIZE(LIST([Task Description]@row, [Notes]@row))
```

## Examples

The AISUMMARIZE function changes long text into a short summary. This keeps the sheet easy to read.

- The input can come from one column. It can also come from more than one column with LIST().
- The optional instructions control the length, the tone, or the subject.
- The system writes the values after it completes the AI event. The cell can be empty for a short time after you set the formula.


#### Example

You have a sheet with two text columns:

- Task Description
- Notes


You want a new column with the name **Summary**. This column shows both texts as one line for status reviews.

| Row | Task Description | Notes | Summary |
|  --- | --- | --- | --- |
| 1 | Migrate the reporting database to the new cluster, validate replication, and cut over during the maintenance window. | Coordinate with the infra team; rollback plan required. | DB migration with validated replication and coordinated cutover; rollback plan in place. |
| 2 | Draft the Q3 customer newsletter covering the new integrations, pricing update, and webinar schedule. | Marketing to review before send. | Q3 newsletter draft covering integrations, pricing, and webinars; pending marketing review. |


In the **Summary** column, use this column formula:

**=AISUMMARIZE(LIST([Task Description]@row, [Notes]@row), "Keep under 100 characters")**

#### How it works:

- **LIST([Task Description]@row, [Notes]@row)**: This part puts the values from the two columns into one input for the AI.
- **"Keep under 100 characters"**: This instruction sets a length limit for each summary.
- **AISUMMARIZE(...)**: The function collects the parameters during the column formula calculation. Then it sends an AI event. The system writes the summary in the cell of each row when it completes the event.


The result is a short summary in each row. No manual work is necessary.

## Related functions

- AITRANSLATE
- AISENTIMENT
- LIST