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): 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 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): Unique identifier of the row

Output

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