Add Row

Create a new row in a Smartsheet sheet.

Note: Smartsheet only allows 5000 rows per 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

Row Position

  • Top of Sheet - Adds the row at the top of the sheet.
  • Bottom of Sheet - Adds the row at the bottom of the sheet.
  • Above Row - Adds the row above a row that you specify.
  • Below Row - Adds the row below a row that you specify.
  • To Parent Row (top) - Adds the row as the top child row to a parent row that you specify.
  • To Parent Row (bottom) - Adds the row as the bottom child to a parent row that you specify.
Dropdown FALSE

Input

The input fields for this card are dynamically generated based on your instance.

Note

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

Field Definition Type Required
Sheet
ID The unique identifier of the sheet you want to use. String TRUE
Columns

Output

Field Definition Type
Row
id The Smartsheet ID for the created row. String
rowNumber The number assigned to the newly created row. String

Related topics

Smartsheet connector

About the elements of Okta Workflows

Smartsheet API Reference