Adding rows to an existing Smartsheet

Know how to add rows to an existing Smartsheet.

Procedure

  1. Add the Smartsheet connector to the canvas and connect it to the Start icon.
  2. Double-click the Smartsheet connector, and select the Add Rows action from the Select Action drop-down list.
  3. Select or add the account for Smartsheets that you want to use to run this action.
  4. Click Next.
  5. Add the following details in the action configuration window.
    • Sheet ID - Select or specify the ID of the sheet in which you want to add rows.
    • Row Location (Mandatory) - Select the location where you want to add a row from the options given under the drop-down list. If you select the Child of Parent option, you must enter the Parent ID, and if you select Sibling, you must enter the Sibling ID.
      Note: Child of Parent adds a row as a child of the specified row and Sibling adds a row at the same hierarchical level of the specified row.
    • Parent ID - Select the ID of the parent row. The new row is added as the first child of the parent row.
    • Insert Row in the Child List At - Select the position of the row that you want to add.

    You can add multiple rows and columns by clicking the Add link.

  6. After you have entered the relevant details, click Next, test the action, and click Done.
  7. Save the workflow and click Test. A new row is added along with the value, if any, at the specified location. To see the reflected changes, refresh the selected sheet in Smartsheet.