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 FALSE

    Input

    Field Definition Type Required
    Row
    id The Smartsheet ID of the row to update. String 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 String 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

    About the elements of Okta Workflows

    Smartsheet API Reference