Procedures
Automation procedures in the Smartsheet book.
Ensure that you have installed or connected the Smartsheet book and created a new playground before using these automation procedures.
to add some content to a sheet
Append the contents of a table into an existing sheet.
Input Concepts
content
The table object to append.
table
Yes
(no default)
Output Concepts
Examples
Append the contents of a table in a sheet
get a sheet whose name is "Invoices"
>>>
create a table where
the column names are "Product Id", "Price"
insert a row in the table where
the Product Id is "00003"
the Price is 313
use the table as the content
>>>
add the content to the sheetto get some (sheet's columns)
Get a sheet's columns.
Input Concepts
Output Concepts
Examples
Get the sheet's columns
get a sheet whose name is "Invoices"
get the sheet's columnsto get some (sheet's rows)
Get a sheet's rows.
Input Concepts
Output Concepts
Examples
Get the sheet's rows
get a sheet whose name is "Invoices"
get the sheet's rowsto get some (sheets)
Gets all sheets.
Output Concepts
Examples
Get all sheets
get some sheetsGet a sheet by name
get the sheet whose name is "Products"to get some (workspaces)
Gets all workspaces.
Output Concepts
Examples
Get all workspaces
get some workspacesGet a workspace by name
get a workspace whose name is "Workspace Name"to insert a (new column) in a sheet
Inserts a column in a sheet.
Input Concepts
name
Name of column to add
text
Yes
(no default)
column type
Type of column to add
enum[abstract_datetime, checkbox, contact_list, date, datetime, multi_contact_list, multi_picklist, picklist, predecessor, text_number]
Yes
(no default)
index
Index of column to add (First index is 1)
number
Yes
(no default)
Output Concepts
Examples
Insert a new column at index
get a sheet whose name is "Products"
>>>
insert a new column in the sheet where
the name is "Product Type"
the column type is "TEXT_NUMBER"
the index is 2to insert a (new row) in a sheet
Append a row in a sheet.
Input Concepts
values
List of values to insert
boolean or number or text
Yes
(no default)
Output Concepts
Examples
Append a new row to a sheet
get a sheet whose name is "Documents"
insert a new row in the sheet where
the values are 384230, "Invoice", "Completed"to write the content in a workspace
Set the contents of a table to a new sheet.
Input Concepts
sheet name
The name of the new sheet.
text
Yes
(no default)
content
The table object to set in the sheet.
table
Yes
(no default)
Output Concepts
Examples
Set the contents of a table into a new sheet
get a workspace whose name is "Workspace Name"
>>>
create a table where
the column names are "Product Id", "Price"
insert a row in the table where
the Product Id is "00003"
the Price is 313
use the table as the content
>>>
write the content in the workspace
the sheet name is "Product Sheet"Last updated
Was this helpful?
