Smartsheet - Get column information

Use the Smartsheet - Get column information 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 information about a column in a Smartsheet.

For more information about Smartsheet, go to Smartsheet.

Before you begin: 

Jump to:

Configure the Smartsheet - Get column information 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. Select the Column.

  3. Create or select a variable for the output.

Smartsheet - Get column information 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 column information 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
  Column The column whose information you want to retrieve. This list is populated based on the sheet you chose. Decimal, Integer
Output Column information Stores the result of the action as an object. The following values are returned:
  • 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