Create a Select Column (Beta)
Company Administrators can enable the Forecasting: Worksheet Columns beta in Procore Explore, which starts rolling out on October 21, 2026, and will be available to all accounts by March 2027.
La única página disponible en tu configuración regional preferida del sitio de soporte V2 es la página de la biblioteca de videos. El lanzamiento completo del sitio web llegará pronto.
¿Buscas otro contenido? Vuelve al sitio de soporte V1.
Los manuales del producto más usados en el sitio
Aspectos destacados de los manuales del producto publicados recientemente
Company Administrators can enable the Forecasting: Worksheet Columns beta in Procore Explore, which starts rolling out on October 21, 2026, and will be available to all accounts by March 2027.
A Select Column is a custom column type that allows company administrators to configure a drop-down list of predefined data options (or a manual entry override) for users to choose from in a budget or forecasting view. Select columns support multiple formats, such as Currency, Number, Percent, and Quantity.
When you assign a select column to a budget or forecasting view, the cells in that view will automatically display values based on the default option or cost type override rule. You can click the drop-down menu in the cell of the select column to override the source data with another option, or you can choose "Lump Sum Manual Entry" to manually enter a value.
Required User Permissions:
'Admin' level permissions on the Company level Admin tool.
'Standard' or 'Admin' level permissions on the Project level Budget tool.
Additional Information:
You can add up to 60 select columns to a single budget or forecasting view. See Assign Columns to a Budget or Forecast View.
Show / Hide Steps
Navigate to the Company level Admin tool.
Under 'Tool Settings', click Budget.
Select the Columns tab.
Click + Create and select Select Column.
Under 'General Information', configure the following:
Default Column Name. Enter a name for the select column.
Note: You can assign a different display name when managing a budget or forecasting view.
Format. Select a data format for the select column's output from the drop-down list:
Currency. Displays values with standard monetary formatting and two decimal places. For example, $2,400,999.00.
Number. Displays values as whole numbers. For example, 2,400,000.
Percent. Displays values as percentages. For example, 240,000,000.00%.
Quantity. Displays values as numerical amounts. For example, 995.00 lf.
(Optional) Include column in Single Tool Budget reports. Mark this checkbox to include the budget column in Single Tool - Budget reports.
Under 'Select Options', configure the following:
Add Option. Click to select existing budget columns that match the selected column format.
Note: You must add a minimum of two (2) options and can add up to ten (10) options per column. Reorder options using the drag handle
icon.
No Value Option: Select columns can include a No Value option (added once per column). Selecting No Value displays as - - in the cell and impacts calculations as follows:
Vertical Aggregation (Totals/Subtotals): Procore skips "No Value" cells during vertical summation and does not count them toward totals.
Horizontal Formulas (Row Calculations): If a row formula references a "No Value" cell (resulting from selection criteria or cost type display rules), the formula does not break with a #CALC error and instead evaluates "No Value" based on the operator:
Addition: Treated as 0 (e.g., 50 + No Value = 50)
Subtraction: Treated as 0 (e.g., 50 - No Value = 50)
Multiplication: Treated as 1 (e.g., 50 × No Value = 50)
Division: Treated as 0 when used as the dividend (e.g., No Value / 50 = 0), but generates a #CALC error when used as the divisor (e.g., 50 / No Value = #CALC)
Error Propagation: Any #CALC error in a row propagates vertically, displaying a dash (—) for any column subtotal or grand total that incorporates it.
Make default option. Select the radio button next to an option to set it as the default selection across all budget rows.
(Optional) Override default option by cost type (optional). Specify cost types (e.g., Allowance, Contingency) to automatically override the default selection for matching line items.
Note: Available for options that are not set as the default option.
Select cost types. Click to select one or more cost types.
Note: You can add cost types in the Company level Admin tool. See Add Company Cost Types.
(Optional) Enable lump sum manual entry. Mark this checkbox to include a Lump Sum Manual Entry option in the drop-down menu of the select column in budget views. This option lets users manually enter a custom value into the cell instead of selecting a predefined column value.
(Optional) Under 'Data Display', configure the following:
Display subtotals and grand totals. Clear this checkbox to hide subtotals and grand totals for line items.
Note: Available for numerical formats (Currency, Number, and Quantity).
Only show values in this column for certain cost types. Mark this checkbox to dynamically show or hide values and options within this column based on cost types.
When cost type. Select Includes or Excludes from the drop-down list.
value of. Select one or more cost types from the drop-down list.
Up to 10 cost types are displayed at a time. To find additional cost types, enter keywords for cost types in the search field.
If your company uses both ERP-synced cost types and Procore standard cost types, ensure your column definitions account for both sets. You can manage this in one of two ways:
Option 1 (Separate Columns): Create separate columns specifically for ERP cost types and another for Procore standard cost types.
Option 2 (Single Column): Set up one column that includes both ERP and Procore standard cost types.
Click Create.
The new select column will appear in the Columns list.
Show / Hide Steps
On the 'Budget View' page, click + Create in the Columns panel.
Select Select Column.
Under 'General Information', configure the following:
Default Column Name. Enter a name for the select column.
Note: You can assign a different display name when managing a budget view.
Format. Select a data format for the select column's output from the drop-down list:
Currency. Displays values with standard monetary formatting and two decimal places. For example, $2,400,999.00.
Number. Displays values as whole numbers. For example, 2,400,000.
Percent. Displays values as percentages. For example, 240,000,000.00%.
Quantity. Displays values as numerical amounts. For example, 995.00 lf.
(Optional) Include column in Single Tool Budget reports. Mark this checkbox to include the budget column in Single Tool - Budget reports.
Under 'Select Options', configure the following:
Add Option. Click to select existing budget columns that match the selected column format.
Note: You must add a minimum of two (2) options and can add up to ten (10) options per column. Reorder options using the drag handle
icon.
No Value Option: Select columns can include a No Value option (added once per column). Selecting No Value displays as - - in the cell and impacts calculations as follows:
Vertical Aggregation (Totals/Subtotals): Procore skips "No Value" cells during vertical summation and does not count them toward totals.
Horizontal Formulas (Row Calculations): If a row formula references a "No Value" cell (resulting from selection criteria or cost type display rules), the formula does not break with a #CALC error and instead evaluates "No Value" based on the operator:
Addition: Treated as 0 (e.g., 50 + No Value = 50)
Subtraction: Treated as 0 (e.g., 50 - No Value = 50)
Multiplication: Treated as 1 (e.g., 50 × No Value = 50)
Division: Treated as 0 when used as the dividend (e.g., No Value / 50 = 0), but generates a #CALC error when used as the divisor (e.g., 50 / No Value = #CALC)
Error Propagation: Any #CALC error in a row propagates vertically, displaying a dash (—) for any column subtotal or grand total that incorporates it.
Make default option. Select the radio button next to an option to set it as the default selection across all budget rows.
(Optional) Override default option by cost type (optional). Specify cost types (e.g., Allowance, Contingency) to automatically override the default selection for matching line items.
Note: Available for options that are not set as the default option.
Select cost types. Click to select one or more cost types.
Note: You can add cost types in the Company level Admin tool. See Add Company Cost Types.
(Optional) Enable lump sum manual entry. Mark this checkbox to include a Lump Sum Manual Entry option in the drop-down menu of the select column in budget views. This option lets users manually enter a custom value into the cell instead of selecting a predefined column value.
(Optional) Under 'Data Display', configure the following:
Display subtotals and grand totals. Clear this checkbox to hide subtotals and grand totals for line items.
Note: Available for numerical formats (Currency, Number, and Quantity).
Only show values in this column for certain cost types. Mark this checkbox to dynamically show or hide values and options within this column based on cost types.
When cost type. Select Includes or Excludes from the drop-down list.
value of. Select one or more cost types from the drop-down list.
Up to 10 cost types are displayed at a time. To find additional cost types, enter keywords for cost types in the search field.
If your company uses both ERP-synced cost types and Procore standard cost types, ensure your column definitions account for both sets. You can manage this in one of two ways:
Option 1 (Separate Columns): Create separate columns specifically for ERP cost types and another for Procore standard cost types.
Option 2 (Single Column): Set up one column that includes both ERP and Procore standard cost types.
Click Create.
The new select column is enabled by default in the budget view. You can toggle its visibility on or off using the toggle switch in the panel. See Enable or Disable Columns in a Budget or Forecasting View.
The new select column will automatically appear on the far right of the budget view table in the project's Budget tool.
Show / Hide Steps
Follow the relevant steps to create or edit a forecasting view.
On the 'Forecasting View' page, click + Create in the Columns panel.
Select Select Column.
Under 'General Information', configure the following:
Default Column Name. Enter a name for the select column.
Note: You can assign a different display name when managing a forecasting view.
Format. Select a data format for the select column's output from the drop-down list:
Currency. Displays values with standard monetary formatting and two decimal places. For example, $2,400,999.00.
Number. Displays values as whole numbers. For example, 2,400,000.
Percent. Displays values as percentages. For example, 240,000,000.00%.
Quantity. Displays values as numerical amounts. For example, 995.00 lf.
(Optional) Include column in Single Tool Budget reports. Mark this checkbox to include the budget column in Single Tool - Budget reports.
Under 'Select Options', configure the following:
Add Option. Click to select existing budget columns that match the selected column format.
Note: You must add a minimum of two (2) options and can add up to ten (10) options per column. Reorder options using the drag handle
icon.
No Value Option: Select columns can include a No Value option (added once per column). Selecting No Value displays as - - in the cell and impacts calculations as follows:
Vertical Aggregation (Totals/Subtotals): Procore skips "No Value" cells during vertical summation and does not count them toward totals.
Horizontal Formulas (Row Calculations): If a row formula references a "No Value" cell (resulting from selection criteria or cost type display rules), the formula does not break with a #CALC error and instead evaluates "No Value" based on the operator:
Addition: Treated as 0 (e.g., 50 + No Value = 50)
Subtraction: Treated as 0 (e.g., 50 - No Value = 50)
Multiplication: Treated as 1 (e.g., 50 × No Value = 50)
Division: Treated as 0 when used as the dividend (e.g., No Value / 50 = 0), but generates a #CALC error when used as the divisor (e.g., 50 / No Value = #CALC)
Error Propagation: Any #CALC error in a row propagates vertically, displaying a dash (—) for any column subtotal or grand total that incorporates it.
Make default option. Select the radio button next to an option to set it as the default selection across all budget rows.
(Optional) Override default option by cost type (optional). Specify cost types (e.g., Allowance, Contingency) to automatically override the default selection for matching line items.
Note: Available for options that are not set as the default option.
Select cost types. Click to select one or more cost types.
Note: You can add cost types in the Company level Admin tool. See Add Company Cost Types.
(Optional) Enable lump sum manual entry. Mark this checkbox to include a Lump Sum Manual Entry option in the drop-down menu of the select column in budget views. This option lets users manually enter a custom value into the cell instead of selecting a predefined column value.
(Optional) Under 'Data Display', configure the following:
Display subtotals and grand totals. Clear this checkbox to hide subtotals and grand totals for line items.
Note: Available for numerical formats (Currency, Number, and Quantity).
Only show values in this column for certain cost types. Mark this checkbox to dynamically show or hide values and options within this column based on cost types.
When cost type. Select Includes or Excludes from the drop-down list.
value of. Select one or more cost types from the drop-down list.
Up to 10 cost types are displayed at a time. To find additional cost types, enter keywords for cost types in the search field.
If your company uses both ERP-synced cost types and Procore standard cost types, ensure your column definitions account for both sets. You can manage this in one of two ways:
Option 1 (Separate Columns): Create separate columns specifically for ERP cost types and another for Procore standard cost types.
Option 2 (Single Column): Set up one column that includes both ERP and Procore standard cost types.
Click Create.
The new select column is enabled by default in the forecasting view. You can toggle its visibility on or off using the toggle switch in the panel. See Enable or Disable Columns in a Budget or Forecasting View.
The new select column will automatically appear on the far right of the forecasting view table in the project's Budget tool.
Loading related articles...