> For the complete documentation index, see [llms.txt](https://formulapro.shadebridge.com/formula-pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://formulapro.shadebridge.com/formula-pro/formula-pro-custom-functions/mirror.md).

# Mirror Column Functions

These functions evaluate conditions on **comma-separated mirror column values** — the aggregated values from all items connected via a mirror column. Use them in formulas triggered by mirror column changes.

**Input format:** `values` is a comma-separated string, e.g. `"Done, In Progress, Done"`.

***

## ALL\_MIRROR\_VALUES\_MATCH\_CONDITION

Returns `true` if every value matches the condition.

**Syntax:** `ALL_MIRROR_VALUES_MATCH_CONDITION({mirror column}, condition)`

**Example:**

```
ALL_MIRROR_VALUES_MATCH_CONDITION("Done, Done, Done", "Done")
```

**Result:** `true`

**Example:**

```
ALL_MIRROR_VALUES_MATCH_CONDITION("Done, In Progress, Done", "Done")
```

**Result:** `false`

***

## NO\_MIRROR\_VALUES\_MATCH\_CONDITION

Returns `true` if no value matches the condition.

**Syntax:** `NO_MIRROR_VALUES_MATCH_CONDITION({mirror column}, condition)`

**Example:**

```
NO_MIRROR_VALUES_MATCH_CONDITION("In Progress, Pending", "Done")
```

**Result:** `true`

***

## AT\_LEAST\_ONE\_MIRROR\_VALUE\_MATCHES\_CONDITION

Returns `true` if at least one value matches the condition.

**Syntax:** `AT_LEAST_ONE_MIRROR_VALUE_MATCHES_CONDITION({mirror column}, condition)`

**Example:**

```
AT_LEAST_ONE_MIRROR_VALUE_MATCHES_CONDITION("Done, In Progress, Pending", "Done")
```

**Result:** `true`

***

## SOME\_MIRROR\_VALUES\_MATCH\_CONDITION

Returns `true` if some (but not all) values match the condition.

**Syntax:** `SOME_MIRROR_VALUES_MATCH_CONDITION({mirror column}, condition)`

**Example:**

```
SOME_MIRROR_VALUES_MATCH_CONDITION("Done, Done, In Progress", "Done")
```

**Result:** `true` (2 match, 1 doesn't)

**Example:**

```
SOME_MIRROR_VALUES_MATCH_CONDITION("Done, Done, Done", "Done")
```

**Result:** `false` (all match, not "some")

***

## HALF\_MIRROR\_VALUES\_MATCH\_CONDITION

Returns `true` if at least half of the values match the condition.

**Syntax:** `HALF_MIRROR_VALUES_MATCH_CONDITION({mirror column}, condition)`

**Example:**

```
HALF_MIRROR_VALUES_MATCH_CONDITION("Done, Done, In Progress", "Done")
```

**Result:** `true` (2 of 3 ≥ half)

***

## PERCENTAGE\_OF\_MIRROR\_VALUES\_MATCH\_CONDITION

Returns `true` if the percentage of matching values meets or exceeds the threshold.

**Syntax:** `PERCENTAGE_OF_MIRROR_VALUES_MATCH_CONDITION(values, condition, percentage)`

| Parameter  | Description     |
| ---------- | --------------- |
| values     | Mirror column   |
| condition  | Value to match  |
| percentage | Threshold 0–100 |

**Example:**

```
PERCENTAGE_OF_MIRROR_VALUES_MATCH_CONDITION("Done, Done, In Progress, Pending", "Done", 50)
```

**Result:** `true` (50% match)