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

Related topics

Smartsheet connector

Workflow elements

Smartsheet API Reference