Description
The QUESTION function fetches one scored question from a company's scorecard, including its answer value, score and SIG Analysis, from the Novata API.
Syntax
=NOV.QUESTION(company, rubric, reportingPeriod, category, question, fieldName)
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
company |
String | Required | Company name as shown on the scorecard (e.g. "The Clean Co"), or its Company Id. |
rubric |
String | Required | Rubric name (e.g. "ESG Rubric") or Rubric Id. A name always means the active rubric; use the Rubric Id for an archived rubric. |
reportingPeriod |
String | Required | Reporting period, in the same formats as NOV.ANSWER: "2024", "Q3 2024", "H1 2024" or "Jan 2025". |
category |
String | Required | Category name the question belongs to (not case-sensitive). |
question |
String | Required | Question label as shown on the scorecard (not case-sensitive). |
fieldName |
String | Required | The question field to return (see available fields below). |
Available Field Names
You can use any of the following field names as the fieldName parameter:
display_value
The answer the question was scored on, as text
numeric_value
The answer as a number, for numeric questions only (otherwise #N/A)
score
Question score
metric_reference
Reference of the linked metric, if any
context
SIG Analysis (scoring rationale) saved on the question
Examples
Example 1: Get a numeric answer
=NOV.QUESTION("The Clean Co", "ESG Rubric", "2024", "Environmental", "Scope 1 Emissions", "numeric_value")
Result: 1200
Example 2: Get a question score
=NOV.QUESTION("The Clean Co", "ESG Rubric", "2024", "Environmental", "Scope 1 Emissions", "score")
Result: 9
Example 3: Get the SIG Analysis
=NOV.QUESTION("The Clean Co", "ESG Rubric", "2024", "Environmental", "Scope 1 Emissions", "context")
Result: "Verified by third party"
Important Notes
Note:
- Company, rubric, category and question names match what the Scorecard Management panel inserts, ignoring case and surrounding spaces.
- A rubric name only matches the active rubric. For a rubric that has been archived, use its Rubric Id.
- Archived scorecards are ignored.
- Field names are case-sensitive. Use the exact field names listed above.
- Make sure you're logged into the Novata Excel Add-in before using this function.
Related Functions
NOV.SCORE - Retrieve scorecard totals
NOV.CATEGORY - Retrieve scorecard category data
NOV.ANSWER - Retrieve answer data
NOV.COMP - Retrieve company attributes