Smartsheet Dropdown Not Updating in Destination Sheet

Symptoms: You have updated values in your master source sheet, but those changes are not appearing in the dropdown menus of your destination Smartsheet sheets. New entries are missing, or deleted entries still appear as options.

Technical Explanation

Dynamic Dropdown utilizes Smartsheet Webhooks to monitor your source sheet for changes. When a row is saved in Smartsheet, a notification is sent to SmartSyncApp, which then triggers a sync job to update all mapped destination columns. If this chain is broken—at the webhook registration level, the API authorization level, or the sheet property level—the destination dropdowns will become out of sync with the source.

Root Causes and Fixes

1. Inactive Mapping Status: Configurations can be manually or automatically paused. Fix: Log in to the SmartSyncApp dashboard and ensure the toggle for this specific mapping is set to "Active." If it was inactive, a manual sync will be required to catch up on missed changes.
2. Webhook Callback Failure: Smartsheet automatically disables webhooks if they fail to deliver a notification after multiple retries. This can happen during temporary server maintenance or API outages. Fix: Click the "Refresh Webhook" button in your mapping settings to re-register the hook with Smartsheet.
3. Connection Permission Issues: If the user who set up the mapping has their Smartsheet permissions downgraded to "Viewer" on either the source or destination sheet, the sync will fail. Fix: Navigate to Settings > Connections and verify the account has at least "Admin" access to the source (for webhooks) and "Editor" access to destinations.
4. Smartsheet Column ID Mismatch: If the destination column was deleted and re-created with the same name, Smartsheet assigns it a new internal ID, which breaks the mapping. Fix: Open the mapping configuration, re-select the destination column from the dropdown list, and save.

Advanced Resolution Steps

• Trigger a Full Resync: From the dashboard, select "Run Manual Sync." This bypasses the webhook and performs a complete read/write operation for all destination sheets, ensuring they match the current source state perfectly.
• Inspect Sync Logs: Review the SmartSyncApp logs for specific Smartsheet API error codes like 1004: Sheet Not Found or 1006: Locked. This provides the exact reason why Smartsheet rejected the update.
• Check for Concurrent Edits: If multiple users are editing the same dropdown column in Smartsheet simultaneously, the API may return a conflict error. SmartSyncApp has built-in retry logic, but extreme contention can lead to sync delays.

Proactive Prevention

To ensure maximum reliability, we recommend creating a Dedicated Audit Column in your source sheet. Use a formula like =COUNT(NAME:NAME) to quickly verify that the source count matches what you expect in the dropdown. Additionally, always use Service Accounts for Smartsheet connections to avoid sync breaks when individual team members change roles or permissions. Implementing a simple "Last Updated" timestamp in your destination sheets can also help your team verify at a glance that the data is current and actively maintained by the automation engine.