SmartSheeet Integration / update existing rows in smartsheet

Help Activities
, , ,
1

Hi Team,
I am trying to update multiple rows of Smartsheet, by looping into the data.
Can anyone help to use “Sheets_rowsCells” which should be provided as input in the field “Cells” of the Update row activity?
Or how can I update specific column of the Smartsheet by iterating through each row?

Thanks
Harshita

2

@Harshita

  1. First use listrows activitiy and get the rows you needed
  2. Then use the putput of 1 in the update rows activity Rows field…and then provide datatable of what column value to be updated.Below is the datatable structure

IMG_6462
IMG_6462828×429 49.6 KB

https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-update-rows

Hope this helps

Cheers

3

Thank You @Anil_G . I will try the solution and revert back.

1 Like