Reference Value Not Found in Smartsheet

Symptoms: The user enters a reference value into the lookup field and receives a "No matching record found" error message, even if they believe the record exists in your Smartsheet.

Technical Explanation

SmartSyncApp's Smart Form performs an exact-match query against the designated reference column in your Smartsheet sheet. This means that any discrepancy—including hidden whitespace, capitalization differences, or formatting variations—will cause the lookup to fail. The tool is designed to be precise to ensure users never accidentally update the wrong row.

Root Causes and Fixes

1. Case Sensitivity: Smartsheet identifiers are often case-sensitive. If your sheet contains "EMP-101" and the user enters "emp-101", the system will not find a match. Fix: Ensure your instructions to users clearly state the required case format, or use a Smartsheet formula to standardize the reference column to all-caps.
2. Hidden Whitespace: Leading or trailing spaces in the Smartsheet cell are the most common cause of "not found" errors. A value like " 12345" will not match "12345". Fix: Use the Smartsheet TRIM() function in a helper column to clean your data, and map that helper column as the Reference Field in SmartSyncApp.
3. Incorrect Reference Column: You may have mapped the form to a column that contains duplicates or non-unique values. Fix: Open the Smart Form configuration in SmartSyncApp and verify that the "Reference Column" setting matches the column where the user-provided IDs are stored.
4. Row Archiving: If you use an archiving workflow that moves rows to a different sheet, the Smart Form (which is linked to a specific sheet ID) will no longer see those rows. Fix: Ensure the rows remain in the sheet that is actively connected to the form configuration.

Advanced Resolution Steps

• Check for "Text-as-Number" Issues: In Smartsheet, a number formatted as text (with a leading apostrophe) will not match a numeric input. Ensure the column type and formatting are consistent.
• Verify Webhook Sync: While lookup is real-time, if you just added the row seconds ago, ensure the Smartsheet API has processed the addition.

Proactive Prevention

To reduce lookup errors, we recommend using a Barcode or QR Code deployment. By encoding the reference value directly into the URL, users don't have to type anything, eliminating manual entry errors entirely. Additionally, implementing Data Validation on your reference column within Smartsheet prevents duplicate or malformed IDs from being entered at the source.