---
sourceDocument: Australia Operational Sustainability Management (formerly Environmental, Social, and Governance)
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/environmental-social-governance

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Operational Sustainability Management (formerly Environmental, Social, and Governance)

ft:clusterId :

    - esgv

bundleId :

    - esgv

workflow :

    - Technology


---

# Create a unique metric definition name

# Create a unique metric definition name {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Specify the value formula in the sn_grc_metric_definition in the required record
table to create unique metric definition names to import data from an external source such
as Watershed spreadsheets.

## Before you begin

Role required: sn_grc_metric.admin

## About this task

Any external source that contains data must be imported into the metric definitions and each metric definition must have a unique name. The metric definition name can either use a single column from the spreadsheet or it can be a combination of multiple columns. This procedure uses the Operational Sustainability Integration with Watershed and the sn_grc_metric_definition table as an example. You can specify the formulae in the sn_grc_metric_definition table to create the unique metric definition names. The same procedure can be repeated for the other tables as well. The following tables are installed by default.

* sn_grc_profile
* sn_grc_profile_type
* sn_grc_metric_definition

{#create-unique-metric-definition-names__ul_zvx_rd2_ftb} The following image shows the string and value columns from a sample spreadsheet.Figure 1. Value formula combinations

## Procedure

1. Navigate to AllMetricsMetric Integrations.
2. Select Watershed Integration.
3. In the Data Mappings section, select the data mapping for which you want to specify the formula.
4. On the Required Records form, in the Value Formulas section select New.
5. On the form, fill in the fields.  
   {#create-unique-metric-definition-names__table_tcw_htp_3tb__entry__2}

   | Field | Description |
   |-|-|
   | Source table. | Name of the source table. This field is automatically set to Watershed Data \[sn_esg_watershed_data\]. |
   | Required record | Name of the table being modified. Note: In this procedure, the example used is the sn_grc_metric_definition table. |
   | Column | Column containing GHG protocol category. |
   | Format | Format of the name. The choices are as follows * String: Use this option to specify a text string. * Value: Use this option to use any value of the column. * String+Value: Use this option prepend text to beginning of column value. * Value+String: Use this option to append text to end of column value. Specify the text in the String field. {#create-unique-metric-definition-names__ul_qsd_r5p_3tb} |
   | String | Text to use in the format. |
   | Sequence | Specify the sequence of the formula. Multiple value formula under same required record will be concatenated following the sequence specified. |
   [Table 1. Value Formula form]

   {#create-unique-metric-definition-names__table_tcw_htp_3tb}
6. Select Submit.

*[\>]: and then