Update Row

Update a row in a sheet.

Required fields are indicated in red.

Options

  • Your Smartsheet sheets (dropdown): 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.

Input

Row * id (text): Smartsheet id of the row to update

Location * Row ID (text): 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 * Position (dropdown): The position of the current row relative to Row ID. * Do Not 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.

Sheet * ID (text): Smartsheet id of the sheet that contains the row to update

Columns

The output fields are dynamically generated based on your instance.

If the Restrict to checkbox at the bottom of the Insert Column or Edit Column Properties form is checked in the Smartsheet UI, you need to fill in the correct data to pass data validation.