How to get Row ID or Original ID in Smartsheet

Options
ManuelMO
ManuelMO
edited 12/09/19 in Smartsheet Basics

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

Thank you!

Comments

  • Shaine Greenwood
    Options

    Hi Manuel—

    Right-click the row in your sheet and select Properties.

    You'll see the Row ID there!

  • EGrosshans
    Options

    Is there a formula to "grab" the "original ID" or "Rowid" and populate a column with it?  

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 03/08/19
    Options

    Hi,

    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!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • ipeat
    ipeat ✭✭
    Options

    Is there a way to upvote enhancement requests?

  • Ezra
    Ezra ✭✭✭
    Options
  • Hi SmartSheet Community ,

    I want to know the row IDs for a given sheet using a API, is there any dedicated API available ? Thanks

  • Sondra C.
    Options

    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):

    1. Add a column in your Smartsheet called "Row ID"
    2. Create a Zap where "When this happens..." references the row (my trigger is, when a new row is created in the Smartsheet)
    3. This will store the specific ID for that row as a data field.
    4. The next step ("Do This...") should be New Row Update in Smartsheet
    5. Select the same sheet as in Step 1
    6. You can grab the Row ID from Step 1
    7. Scroll down to the "Row ID" column you created and enter the Row ID data again from Step 1, this time it will enter it as a text line in your Smartsheet.
  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Options

    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)

    Trigger: Anything
      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.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • Trevor Penner
    Options

    Thanks Sondra! This worked perfectly for me. Hopefully they add this as just a function in the future, but this works for now.

  • Mark Salamon
    Options

    Does anyone know if this feature was ever added?

  • Samuel Mueller
    Samuel Mueller Overachievers
    Options

    How do I in turn get this information back into the sheet in a column on the specific row?

  • Brett Wyrick
    Brett Wyrick ✭✭✭✭
    Options

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

    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.

    Love,

    Brett Wyrick | Connect with me on LinkedIn.

    ------------------------------------------------------------------------------

    2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!

  • kmelnich
    Options

    The inability of Power Automate flow to find the Row ID of moved/copied rows is only happening with the rows I moved/copied manually from one Smartsheet to another.

    While my flow was failing during tests with these items, rows that were moved automatically by Smartsheet worked as expected with Row ID from trigger output "When a new row is created."

    Trigger - When a new row is created - your Smartsheet source sheet

    Get sheet data - gets the data from the source sheet

    Initialize variable - you are creating an array of your sheet data; "Value" for this array is "value" from the output of your dynamic schema (previous step; choose from Dynamic Content dropdown)

    Using the same source sheet ID for the Smartsheet actions "Add a discussion to a row" and "Add a comment to a discussion":

    The "Add a comment to a discussion" step relies on the "Add a discussion to a row" step

    I then have an automated workflow in the Smartsheet source sheet that moves the row to an archive sheet when a comment is added, which is what this flow does.

    It took me 2 days to figure out that my flow was failing only on the rows that I manually moved so I hope that helps!

    Kristina M.