Adding rows to an existing Smartsheet
Know how to add rows to an existing Smartsheet.
Procedure
- Add the Smartsheet connector to the canvas and connect it to the Start icon.
- Double-click the Smartsheet connector, and select the Add Rows action from the Select Action drop-down list.
- Select or add the account for Smartsheets that you want to use to run this action.
- Click Next.
- 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.
- After you have entered the relevant details, click Next, test the action, and click Done.
- 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.