How to add rows to an existing Smartsheet

Add the Smartsheet connector to canvas and connect it to Start icon.

Double-click the Smartsheet connector, and select Add Rows action from the Select Action drop down list. Read more about Creating accounts.

Select/add the account for Smartsheets that you want to use to execute this action.

Once this is done, click Next, and the following details in the action configuration window that appears next:

• Sheet ID: Select/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 Child of Parent option, you have to enter the Parent ID , and if you select Sibling , you have to enter the Sibling ID .

  Note: Child of Parent adds a new row as a child of the specified row and Sibling adds a new 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 this parent row.
• Insert Row in the Child List At: Select the position of the row you want to add.

You add multiple rows and columns by clicking on the ADD link.

Once you have entered the relevant details, click Next, test the action, and click Done.

This will take you back to canvas.

Next, save the workflow and click Test.

This will add a new row (along with the value, if any) at the specified location. To see the reflected changes, refresh the selected sheet in Smartsheet.