Update Row

Update a row in a sheet.

Options

Field Definition Type Required

Your Smartsheet sheets

Select from the list of all available Smartsheet sheets associated with your Smartsheet instance. Choose Insert ID to select a Smartsheet sheet by its ID, which is entered in the Input section.

 Dropdown TRUE

Input

Field Definition Type Required

Row

ID

Smartsheet ID of the row to update.

 Text TRUE

Location

Row ID

If you want to update the location of the row, the ID of the row used to define the new location of the current row.

 Text FALSE

Position

The position of the current row relative to Row ID:

  • Do Note Move: Does not move the row.
  • Top of Sheet: Moves the row to the top of the sheet. Row ID not required for this option, and will be ignored if provided.
  • Bottom of Sheet: Moves the row to the bottom of the sheet. Row ID not required for this option, and will be ignored if provided.
  • Above Row: Moves the row above Row ID.
  • Below Row: Moves the row below Row ID.
  • To Parent Row (Top): Makes the row a child of Row ID, putting it above all other child rows.
  • To Parent Row (Bottom): Makes the row a child of Row ID, putting it below all other child rows.
  • Indent: Keeps the row in current position, but indents it. Row ID not required for this option, and will be ignored if provided.
  • Outdent: Keeps the row in current position, but outdents it. Row ID not required for this option, and will be ignored if provided.
 Dropdown FALSE