Use the NAME function to convert data from a list item to text.
Syntax
NAME(List item)
Arguments
Argument | Data type | Description |
List item | List | The list item to convert to text. |
The NAME function returns a text result.
Syntax example
NAME (Month period)
This returns the month period as a text string where month period is the line item and the result is the name of the month.
Excel Equivalent
Examples
Use NAME with Time
This example shows how you can use the NAME function to return a text formatted line item from the Time list.
The module is displaying the months for 2020.
The NAME calculation function is applied to the line item Month Period formatted as Month and returns the Period Name Month as a line item formatted as text:
Formula | Description | Result |
NAME(Month Period) | The module, Accounts Period, displays the Key Dates and Expiry Dates for a company's accounts. The line items are: Key Dates Expiry Dates The line items and their formats are: Period Name Month (text format) Month Period (time format; Month) | The formula NAME(Month Period) identifies the Month for the Month Period the line item. It then converts the data type from a list item formatted line item to a text. The result displays in the Key Dates and Expiry Dates columns for the Period Name Month line item. |
Source model
Period Name Month: NAME(Month Period)
Accounts period
Key Dates | Expiry Dates | |
Period Name Month
| Feb 20 | Apr 20 |
Month Period | Feb 20 | Apr 20 |
Use NAME with another function
You can use NAME with another function. This example shows how you can use NAME to return the name of a product in text format.
Formula | Description | Result |
NAME(ITEM(Products)) | In this example, a company is looking at the Product Margins for their clothing products. The module is called Product Margins. The list is called Products and is on columns. Line items displays on rows. | The function, NAME references the line item, Product Name., which is list-formatted with the Products list. The formula uses two functions; ITEM and NAME. The ITEM function returns the list item of the line item, then the NAME function converts that list item to text. |
Source model
Product Margins
T-shirts | Dresses | Sweaters | Trousers | Shorts | |
Annual Purchase | 328,765 | 238,976 | 348,432 | 349,876 | 467,831 |
Annual Sales | 404,876 | 289,743 | 401,239 | 378,765 | 502,349 |
Product Season | Summer | Summer | Fall | Fall | Summer |
Rank clothing with same season | 4 | 6 | 4 | 6 | 3 |
Annual Margin | 76,111 | 50,767 | 52,807 | 28,889 | 34,518 |
Product Name
| T-shirts | Dresses | Sweaters | Trousers | Shorts |
The values returned in the Product Name line item have the text data type.