# AISENTIMENT Function

The AISENTIMENT function examines the tone of text from one or more cells. The AI puts the text into one of the configured sentiment categories. 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 category in the cell when it completes the event.

AISENTIMENT 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.

**Column options:** The sentiment labels are the column options. You must configure them. Make the column a PICKLIST. Set the labels in the column options. The default labels are "Positive", "Neutral", and "Negative". The AI puts each row into one of the configured labels.

## Syntax

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

- **data** The text to examine. 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. Example: the part of the text to give attention to.


## Sample usage

```
AISENTIMENT([Review Text]@row, "Focus on customer satisfaction")
```

```
AISENTIMENT(LIST([Subject]@row, [Review Text]@row))
```

## Examples

The AISENTIMENT function changes free text into one value from a fixed set. You can then filter and group the column.

- The input can come from one column. It can also come from more than one column with LIST().
- The output is one of the labels in the column options. The default labels are "Positive", "Neutral", and "Negative".
- The optional instructions point the AI to a part of the text.
- 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 of product reviews:

- Review Text


You want a new PICKLIST column with the name **Sentiment**. The options are "Positive", "Neutral", and "Negative". You can then group the feedback and make charts.

| Row | Review Text | Sentiment |
|  --- | --- | --- |
| 1 | Absolutely love the new dashboard - it saves me an hour every week. | Positive |
| 2 | It works, but setup took longer than expected. | Neutral |
| 3 | Constant crashes since the last update; very frustrating. | Negative |


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

**=AISENTIMENT([Review Text]@row, "Focus on customer satisfaction")**

#### How it works:

- **[Review Text]@row**: This is the source text for each row.
- **"Focus on customer satisfaction"**: This instruction tells the AI to give attention to satisfaction signals.
- **AISENTIMENT(...)**: The function collects the parameters during the column formula calculation. Then it sends an AI event. The AI selects one of the configured options. The system writes the option in the cell of each row when it completes the event.


The result is a sentiment column with fixed values. You can use it for filters, groups, reports, and charts. Example: a pie chart of Positive, Neutral, and Negative reviews.

## Related functions

- AISUMMARIZE
- AITRANSLATE
- LIST