Add Hyperlinks to Columns
Hyperlinks can be added to any column in a table or pivot table. This option is available from each column's menu, under Transform > Set link.
Summary of Content
Requirements
Add a Hyperlink
... from a Formula
... from and Existing URL Column
Remove a Hyperlink
Create a Linked URL Column
Requirements
-
To use this feature, you must have Can Explore or Can Edit access to the individual workbook.
Add a Hyperlink
Add a Hyperlink from a Formula
Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.
-
Hover over the column, and click its caret (▼) button.
This will open the column's menu.
- From the menu's Transform submenu, select Set link.
This will open the Set Link modal.
- Under Link Source select Custom Formula.
- Under Create URL with formula, use Sigma's Concat function to structure your target URL. You can inject columns exactly as you would with Sigma's standard formula bar.
Example: Concat('https://www.plugs-electronics.com/location/', [Store Id])
Note: Any column can be injected into the formula.
- Hit Enter on your keyboard,
or
Click the green checkmark icon to the right of the formula bar to apply the formula.
A preview will appear. - Click Set Link.
Add a Hyperlink from an Existing URL Column
Pre-requisites:
- This method requires that you already have a column with working URLs. It will apply the URLs from the source column as hyperlinks on the values in your selected column.
- This action is only available in edit mode. To begin editing, click Edit in the top right corner of the page.
To add a hyperlink from an existing URL column:
-
Hover over the column, and click its caret (▼) button.
This will open the column's menu. - From the menu's Transform submenu, select Set link.
This will open the Set Link modal.
- Under Link Source select Another Column.
- Under Select column, select the column containing the URL.
A preview will appear under URL Column. - Click Set Link.
Remove a Hyperlink
Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.
- Click your target column's caret icon to open its column menu.
- From the menu's Transform submenu, select Set link....
This will open the Set Link modal. - Click the Remove button located in the modal's footer.
Create a Linked URL Column
This method results in full URLs being displayed in your column's cells. To display text only with a clickable hyperlink, follow the instructions above to Add a Hyperlink.
Before you start: This action uses the editor panel. If you have not done so already, open the editor panel from either Explore or Edit mode.
- Select the column you would like to add a URL to,
or
create a new one. - Using the formula bar and Sigma's Concat function, structure the column's URLs.
Example: Concat('https://www.plugs-electronics.com/location/', [Store Id]) - Hit Enter on your keyboard,
or
Click the green checkmark button to the right of the formula bar.