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:

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:

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:

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

Example:

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:

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:

Result: true (50% match)

Last updated