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)