I need this for an integration with Zapier. Can anyone tell me how to get this number for all rows in a sheet?
Note - Row ID is not Row Number. It should look like this: 5418114689066884
Right-click the row in your sheet and select Properties.
You'll see the Row ID there!
Is there a formula to "grab" the "original ID" or "Rowid" and populate a column with it?
Unfortunately, it's not possible at the moment, but it's a great idea! As far as I know, it's only available thru the API or to check manually.
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic weekend!
Workflow Consultant @ Get Done Consulting
SMARTSHEET PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Is there a way to upvote enhancement requests?
That would be a really super awesome system column option 😀
Hi SmartSheet Community ,
I want to know the row IDs for a given sheet using a API, is there any dedicated API available ? Thanks
I found a workaround through Zapier that will list the Row ID in a column for that specific row. I"m not sure if it will work for everyone the same way, depending on use. (also bear with me, this was surprisingly difficult to explain):
You can get RowId by utilizing Microsoft's automation tool "Power Automate" (formerly known as Microsoft Flow), but it's not the easiest thing to do. If you follow my guide below I try to spell it out..
You can utilize the "When a new row is added" trigger or the "Insert a new row" action, then utilize a "Compose" action to get the row ID. This is also useful for using the "add a new comment to a discussion" action in Flow.
Get RowID when a new row is added (via Microsoft Power Automate):
Trigger: "When a new row is added"
Action: Compose. Expression = substring(string(triggerOutputs()?['body']),6,16)
Get RowID when action "Insert row" occurs (via Microsoft Power Automate)
Action: "Insert row"
Action Following "Insert Row": "Compose". Expression = substring(string(outputs('Insert_row')?['body']),51,16)
Hope this helps. Sadly this won't work for rows already created. Let me know if you have any questions.
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
🧔 Brett Wyrick; your friendly neighborhood freelance consultant & Smartsheet helper.
❓ Need some more help? Want to automate systems outside of Smartsheet to connect to your Smartsheet? Want to automate your sheets to talk to one another easier? Other questions?
Send me an email or connect with me on LinkedIn.
Thanks Sondra! This worked perfectly for me. Hopefully they add this as just a function in the future, but this works for now.
Does anyone know if this feature was ever added?
How do I in turn get this information back into the sheet in a column on the specific row?
@Samuel Mueller - You'd want to utilize the "Insert row" instructions above and get the "Compose" expression to be added in a column of your choosing. Does that make sense?
I've got a way to get this on existing rows now. It's also in Power Automate. It does involve utilizing the "HTTP GET" and the "HTTP POST" functions in Power Automate to make it work. If you're open to utilizing that, I could make a tutorial. It's honestly not that hard, but if you're totally unfamiliar with API's, there will be some prior knowledge needed.