Add Rows

Create multiple new rows in a Smartsheet sheet.

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

  • Row Position (dropdown)

    • 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.

Input

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

Sheet

  • ID(text): The unique identifier of the sheet

Add

  • Rows(list): Each added row is an object. The best way to construct these objects is with a Build Row Object card, accompanied by a List Construct card.

    • For each row added, a build row object card is needed. Each build row object card takes a text input for each column in the associated sheet.

    • Drag the row output on each build row object card into a list construct card.

    • Drag the list output from the list construct card into the rows input on the add rows card.

Location

  • Row ID(text): The unique identifier of the row.

Output

  • Row IDs(list): The list of row IDs for each created Smartsheet row.

See also