cancel
Showing results for 
Search instead for 
Did you mean: 

Update a row in SmartSheet

I would like to be able to update a row in SmartSheet based on other triggers. Of course, the columns would have to be mapped or used in conjunction with the SmartSheet Get Columns action/Get Dynamic Columns action.

Status: New
Comments
Level: Power Up

I would like to do this as well. It seems there are triggers that work off a Create Row action but nothing that works off an update or delete.

 

Is this planned for a future release or am I missing something?

Level: Power Up

I realize that I am late to the party.  I found a work around for this, using a premium connector and the Smartsheet API.

 

My need was when a new row in smartsheet was created, I wanted to create a devops work item and then update that row with the work item id information.  Here's how I did it:

  1. Capture Sheet Id, Row Id, and column ids using the smartsheet connector, you need these variables for the upate.
  2. Created a smartsheet API token in Smartsheet, and initalized a variable in the flow with that information.
  3. Created an HTTP connector with the following settings:
    1. Method: PUT
    2. URI: https://api.smartsheet.com/2.0/sheets/[Sheet ID Variable]/rows
    3. Headers:
      1. Authorization: Bearer [Smartsheet API token]
      2. Content-Type: application.json
    4. Body: [{"id": "[Smartsheet Row ID]", "cells": [{"columnnid": "[Column ID to Update]", "value": "[Whatever value you want]"}]}]
    5. (No Queries, No Cookies, No Authentication)

Let me know if you have any questions, I'd be happy to help.

 

Level: Powered On

Wow, that worked. Thanks!