Info_Columns
Retrieve metadata and properties of columns in Smartsheet sheets or reports, essential for understanding sheet structures.
Table Specific Information
Select
This view returns details for Columns of a specified Sheet. The SheetId parameter is always required.
Retrieve Columns.
SELECT * FROM Info_Columns WHERE SheetId = '2940085806098308'
Retrieve details of the specified Columns.
SELECT * FROM Info_Columns WHERE SheetId = '2940085806098308' AND Id = '7999197812156292'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the column, used to reference it programmatically. | |
| Index | Integer | The numeric position of the column in the sheet, starting at 0 for the first column. | |
| Title | String | The displayed name of the column, as shown in the Smartsheet interface. | |
| Primary | Boolean | Indicates whether this column is the primary column, which typically contains key identifiers or names for rows. | |
| Type | String | The functional data type of the column, such as Text_Number, Date, or Picklist, determining how data is stored and validated. | |
| OptionsAggregate | String | A list of selectable options for the column, applicable for columns like dropdowns or picklists. | |
| Hidden | Boolean | Indicates whether the column is hidden in the Smartsheet interface. | |
| Symbol | String | Represents visual markers or indicators used in the column, with values varying by column type (for example, checkboxes, picklists). | |
| ColumnType | String | Specifies the system-defined column type, such as auto-generated fields like 'created_by' or 'modified_date.' | |
| TagsAggregate | String | Defines system tags for the column, used to indicate roles in features like Gantt charts or calendars (for example, 'gantt_duration'). | |
| Width | Integer | The pixel width used to display the column in the sheet's user interface. | |
| Format | String | The applied formatting settings for the column, such as text alignment or date format. | |
| FilterType | String | Specifies the type of filter applied to the column, with options such as 'list' for predefined values or 'custom' for user-defined filters. | |
| Locked | Boolean | Indicates whether the column is locked, preventing edits by all users except the owner or admin. | |
| LockedForUser | Boolean | Specifies whether the column is locked for the current user based on their permissions. | |
| SheetId | String | The unique identifier of the sheet to which this column belongs. |