The MAKELINK function generates clickable links in a module.
For example, if a module contains information about products you sell, you can create links to the online store page for those products.
Syntax
MAKELINK(Display text, URL)
Arguments
| Argument | Data type | Description |
| Display text | Text | The text that displays for the link. When a user clicks this text, they're taken to the link specified in the URL argument. |
| URL | Text | The URL for the link. |
The result of the MAKELINK function must be a text format line item with a text Type of Link, otherwise the link is not clickable
Calculation engine functionality differences
You cannot currently use the MAKELINK function in Polaris.
In the Classic Engine, you can.
Syntax example
MAKELINK("Click here to view the expenses board", "https://us2a.app.anaplan.com/a/apps/app/2b12f4a4-aba0-4033-9be6-bbc77d86812d/boards/8b30567a-7edd-4c69-aeee-1b6b4ae8dc24")
In this example, the text Click here to view the expenses board is a clickable link. The link goes to an Anaplan board specified in the URL argument.
Constraints
- The MAKELINK function only works with valid HTTP (http://) or HTTPS (https://) URLs.
Excel equivalent
Examples
This example contains a Languages list on columns, and three line items on rows. Two of the line items contain the data for the Display text and URL arguments and one contains a formula that uses this information.
| English | French | German | Japanese | Spanish | |
| Link title | English landing page | French landing page | German landing page | Japanese landing page | Spanish landing page |
| Landing page URL | https://www.anaplan.com/ | https://www.anaplan.com/fr/ | https://www.anaplan.com/de/ | https://www.anaplan.com/jp/ | https://www.anaplan.com/es/ |
Link to landing pages
| English landing page | French landing page | German landing page | Japanese landing page | Spanish landing page |
The result of the formula in the Link to landing pages line item is a clickable link that goes to the respective landing page. You can publish a line item that uses the MAKELINK formula to a dashboard or worksheet to help users access links.
