Add Links to Columns in Workbooks

Summary of Content

Requirements
Add a Hyperlink
      ... from a Formula
      ... from and Existing URL Column
Remove a Hyperlink
Create a Linked URL Column

Requirements

  • You must have Can Edit access on the workbook and be in Editing mode.Editing....png
  • This feature is only available for Text columns.
    If your column does not contain Text values, you can use Sigma's Text function to convert.

Add a Hyperlink

Add a Hyperlink from a Formula

  1. Identify the column on which you would like to add hyperlinks.  
  2. Click the column's caret icon to open its column menu.
    Screen_Shot_2021-07-13_at_3.31.05_PM.png
  3. From the menu's Transform submenu, select Set link....
    This will open the Set Link modal.
    Screen_Shot_2021-07-13_at_3.37.14_PM.png
  4. In the Set Link modal, under the header Link Source, select Custom Formula.
    Screen_Shot_2021-07-13_at_3.42.43_PM.png
  5. 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_2021-07-13_at_4.55.17_PM.png
  6. Hit Enter on your keyboard or click the green checkmark icon to the right of the formula bar to apply the formula. A preview of the selected column's hyperlinks will appear under URL Column.
  7. Click the Set Link button to save your work.Screen_Shot_2021-07-13_at_4.07.57_PM.png

Add a Hyperlink from an Existing URL Column

Pre-requisite: 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. 

  1. Identify the column on which you would like to add hyperlinks.  
  2. Click the column's caret icon to open its column menu.Screen_Shot_2021-07-13_at_4.22.24_PM.png
  3. From the menu's Transform submenu, select Set link....This will open the Set Link modal.
    Screen_Shot_2021-07-13_at_4.23.46_PM.png
  4. In the Set Link modal, under the header Link Source, select Another Column.Screen_Shot_2021-07-13_at_4.29.45_PM.png
  5. Under Select column, select the column containing the URL you would like to use for your selected column's hyperlinks. A preview will appear under URL Column.Screen_Shot_2021-07-13_at_4.32.30_PM.png
  6. Click the Set Link button to save your work.
    Screen_Shot_2021-07-13_at_4.37.14_PM.png

Remove a HyperLink 

  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.

  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. Hit Enter on your keyboard or click the green checkmark icon to the right of the formula bar to apply the formula.