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

11/09/21
Answered - Pending Review

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.

Answers

  • Dale MurphyDale 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.

    dm

  • 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?

    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.‎

Sign In or Register to comment.