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.

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.

  1. Hover over the column, and click its caret (▼) button.
    This will open the column's menu.

  2. From the menu's Transform submenu, select Set link.
    This will open the Set Link modal.

    Screen_Shot_2022-02-03_at_12.45.08_PM.png

  3. Under Link Source select Custom Formula.

    Screen_Shot_2022-02-03_at_12.48.41_PM.png

  4. 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.

    Screen_Shot_2022-02-03_at_12.51.30_PM.png

  5. Press 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.

    Screen_Shot_2022-02-03_at_12.53.34_PM.png

  6. 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:

  1. Hover over the column, and click its caret (▼) button.
    This will open the column's menu.

  2. From the menu's Transform submenu, select Set link.
    This will open the Set Link modal.

    Screen_Shot_2022-02-03_at_12.45.08_PM.png

  3. Under Link Source select Another Column.

  4. Under Select column, select the column containing the URL.
    A preview will appear under URL Column.

    Screen_Shot_2022-02-03_at_1.01.13_PM.png

  5. 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.

  1. Click your target column's caret icon to open its column menu.

  2. From the menu's Transform submenu, select Set link.... This will open the Set Link modal.

  3. 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.

  1. Select the column you would like to add a URL to or create a new one.

  2. Using the formula bar and Sigma's Concat function, structure the column's URLs. 
    Example: Concat("https://www.plugs-electronics.com/location/", [Store Id])

  3. Press Enter on your keyboard or click the green checkmark button to the right of the formula bar.