Smartsheet - Get columns

Use the Smartsheet - Get columns action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve columns from a Smartsheet.

For more information about Smartsheet, go to Smartsheet.

Before you begin: 

Jump to:

Configure the Smartsheet - Get columns action

  1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

  1. Select a Connection. If you do not have a connection, see Add a connection.

  1. Select the Sheet.

  2. Enter paging options if needed.

  3. Create or select a variable for the output.

Smartsheet - Get columns action fields and settings

Section

Field

Description

Variable types

(Unlabeled)

Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

The Smartsheet connection to use to retrieve the columns from a sheet.

To refresh the available connections, click .

(n/a)
  Sheet The sheet name or identity number. This list is populated based on the connection you chose. Decimal, Integer
  Include all results Enable or disable paging options. Boolean
  Page The page number to retrieve, if Include all results is false. Defaults to 1 if not specified. If you specify a value greater than the total number of pages, the last page of results is returned. Decimal, Integer
  Items per page The number of columns per page, if Include all results is false. Decimal, Integer
Output Row Stores the result of the action as an object. The following values are returned:
  • Page number: (Integer) The current page in the full result set that the data array represents. When a page number greater than Total Pages is requested, the last page is instead returned.
  • Total pages: (Integer) The total number of pages in the full result set.
  • Total columns: (Integer) The total number of columns in the full result set.
  • Columns: (Collection)
    • ID: (Integer) The unique ID for the column.
    • Title: (Text) The column title.
    • Type: (Text) One of the following:

      • ABSTRACT_DATETIME

      • CHECKBOX

      • CONTACT_LIST

      • DATE

      • DATETIME

      • DURATION

      • MULTI_CONTACT_LIST

      • MULTI_PICKLIST

      • PICKLIST

      • PREDECESSOR

      • TEXT_NUMBER

      See Column types for more information.

    • Index: (Integer) Column index or position. This number is zero-based.
    • Validation: (Boolean) Indicates whether validation has been enabled for the column.
    • Width: (Decimal) The width of the column in pixels.
 Object