To make the Row ID (SmartSheet) reads its value from (Service Request #) column

After diving deeper in SmartSheet we notice that each row has an auto-generated ID to identify it, but to us what’s more important is our unique Id which is pre-created by our system (Service Request #), we have this unique number stored in specific column with unique value for each row in the sheet.

So our question is there any way to make the Row ID (SmartSheet) reads its value from (Service Request #) column. if so this will make the integration faster and easier especially on Update requests and it will avoid some back and forth API calls.

Thank you for your time and effort, this is all related to an API connection that we want to make.

Find more posts tagged with

Accepted answers

All comments

Dale Murphy

@eduardoleyva007 Not sure why you even care about SmartSheet's auto-generated row ID for this specific application.

Can you not just put your service request # into a column and then reference that with the API you are using? The API should look for the column ID, and find the service request # in that column.

Brett Wyrick

https://community.smartsheet.com/discussion/84817/to-make-the-row-id-smartsheet-reads-its-value-from-service-request-column

To answer the question you have posted: there is no way to override the value for each unique Row ID.

You'll need to utilize the method Dale suggested, which is a lookup of the ColumnID of your "Service Request #" column, then find the applicable value, which will find the Row ID. Does that make sense?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.