Hi! I’m trying to create a workflow between Slack and Smartsheet, using Zapier. The end goal is to be able to send someone a Slack message to a channel (not a DM) with a link to update a specific row on a Smartsheet.
I’m getting stumped by the RowID, and understand there is no look up feature. Is there a way around this? Appreciate any tips.
Thank you!
Lauren
Best answer by Nate
@lchinault - correct, there is no lookup with Smartsheet, so you can’t use row data to find the ID, like you can with Google Sheets. One workaround is to add a Google Sheets row with each new Smartsheet row that includes the row ID plus a unique identifier such as an email address etc. Then lookup Google Sheets for the Smartsheet row ID when you need it. I’ve done this multiple times and it works great.
@lchinault - correct, there is no lookup with Smartsheet, so you can’t use row data to find the ID, like you can with Google Sheets. One workaround is to add a Google Sheets row with each new Smartsheet row that includes the row ID plus a unique identifier such as an email address etc. Then lookup Google Sheets for the Smartsheet row ID when you need it. I’ve done this multiple times and it works great.
Join us September 23rd, 2026 for a free, one-day virtual event with 30+ sessions on AI automation. Get live build-alongs, playbooks, and strategies to lead AI transformation at your organization.