Smartsheet - Get a row

Use the Smartsheet - Get a row action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve the contents of a Smartsheet row.

For more information about Smartsheet, go to Smartsheet.

Before you begin: 

Jump to:

Configure the Smartsheet - Get a row action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  1. Select a Connection. If you do not have a connection, see Add a connection.

  1. Select the Sheet.

  2. Select the Row number.

  3. Create or select a variable for the output.

Smartsheet - Get a row action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Smartsheet connection to use to retrieve the row contents from a sheet.

To refresh the available connections, click .

(n/a)
  Sheet The sheet name. This list is populated based on the connection you chose. (n/a)
  Row number The row number to delete. This list is populated based on the sheet you chose. A variable may also be used, but the variable must use the row ID. Decimal, Integer
Output Row

Stores the result of the action as an object. The following values are returned:

  • ID: (Integer) The unique ID for the row.
  • Sheet ID: (Integer) The parent sheet identity number.
  • Row number: (Integer) The row number.
  • Access level: (Text) User's permission level on the sheet that contains the row.
  • Created at: (Text) The name and email of the creator of this row.
  • Modified at: (DateTime) Time of last modification.
  • Cells: (Collection) The names and value objects of the row's cells.

    See Column types for more information.

If you created a Smartsheet - Get a row action before Dec 9th 2021, the action returned a Collection with the following fields:

  • ID: (Integer) The unique ID for the row.
  • Sheet ID: (Integer) The parent sheet identity number.
  • Row number: (Integer) The row number.
  • Access level: (Text) User's permission level on the sheet that contains the row.
  • Created by: (Text) The name and email of the creator of this row.
  • Created date and time: (DateTime) The time that the row was created.
  • Modified date and time: (DateTime) Time of last modification.
  • Permalink: (Text) URL that represents a direct link to the row in Smartsheet.
  • Cells: (Collection)
    • Column ID: (Integer) The identity number of the column that the cell is located in.
    • Display value: (Text) A visual representation of cell contents, as presented to the user in the UI.
    • Value: (Text) A string, a number, or a Boolean value - depending on the cell type and the data in the cell. Cell values larger than 4000 characters are silently truncated. An empty cell returns no value.
    • Column type: (Text) One of the following:

      • ABSTRACT_DATETIME

      • CHECKBOX

      • CONTACT_LIST

      • DATE

      • DATETIME

      • DURATION

      • MULTI_CONTACT_LIST

      • MULTI_PICKLIST

      • PICKLIST

      • PREDECESSOR

      • TEXT_NUMBER

      See Column types for more information.

    Note: If you drag and drop another Get a row action onto the design canvas, you will get the newest version of this action.

 Object