No Matching Reference Found

A "No Matching Reference" error occurs when Trigger Flow successfully detects a change in the source sheet but cannot locate a corresponding row in the destination sheet using the configured Reference Column. This is the most common troubleshooting issue and is almost always caused by a data alignment problem, not a software bug.

Diagnostic Checklist

Follow this systematic checklist to identify the root cause:

1. Whitespace & Formatting

The most frequent culprit. A value of "PROJ-001 " (with a trailing space) will NOT match "PROJ-001". Use Smartsheet's TRIM() function on the reference column in both sheets to eliminate invisible whitespace characters.

2. Case Sensitivity

Reference matching is case-sensitive by default. "proj-001" will not match "PROJ-001". Standardize casing using Smartsheet's UPPER() or LOWER() functions on the reference column.

3. Missing Destination Rows

If the source sheet has a new record that does not yet exist in the destination, the first sync attempt will log a mismatch. This is expected behavior — Trigger Flow does not create new rows (this is by design to prevent data pollution). Ensure the destination sheet is populated before activating the flow.

4. Column Mapping Error

Verify in your SmartSyncApp dashboard that the Reference Column selected during setup is the correct column. A common mistake is selecting the "Project Name" column instead of the "Project ID" column.

Resolution Steps

1. Export the mismatch log from SmartSyncApp.
2. Cross-reference the failing reference values against both sheets.
3. Clean the data using TRIM/UPPER formulas.
4. Re-test by editing the source cell again.

Prevention: Data Governance Best Practice

Implement a weekly "Reference Alignment Check" by comparing unique values in both sheets. This proactive approach catches drift before it impacts live sync operations.