Smartsheet - Add a row

Use the Smartsheet - Add 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 create and add content to a Smartsheet row.

For more information about Smartsheet, go to Smartsheet.

Before you begin: 

Jump to:

Configure the Smartsheet - Add 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 location.

  3. Depending on the row location selected you may need to select a Parent or Sibling row number.

  4. Configure the values for the Cells of the row. The cells are dynamically read from Smartsheet based on the sheet you selected.

  5. Create or select a variable for the output.

Smartsheet - Add 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 add the row contents to 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 location

The row location to where on the sheet the row should be added.

If you select a Parent or Sibling option, you must then select the row number.

 Text, Decimal, Integer, Boolean, DateTime, Collection
  Cells Once you select the sheet, an input field for each cell of the new row is configurable. The cell name matches the column name. The variable type for each field comes from the data type of the column in the Smartsheet. Text, Decimal, Integer, Boolean, DateTime, Collection
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.

 Object

Considerations

  • Nintex Workflow and Smartsheet support of Date and DateTime differ. Nintex Workflow only supports DateTime while Smartsheet only supports Date. When using the Smartsheet connector actions Nintex Workflow adds a DateTime with the time portion being ignored by Smartsheet. When using the variables in Nintex Workflow the variable type is displayed as DateTime.

  • Custom strings from Smartsheet cannot be parsed in Date variables as this is not supported by Nintex Workflow.

  • Nintex Workflow stores time in UTC format. Workflow and form variables as well as fields which use DateTime must be used with consideration because the browser recognizes the time zone which it is currently in and sends the time in that format. This can result in the wrong day being sent to Smartsheet (e.g. selecting 5 February 2023 10:00 pm in EST equates to 6 February 2023 03:00 am in UTC).