Configure resource link columns

  • Updated on Aug 27, 2024
  • Published on Nov 25, 2022
  • 1 minute(s) read
Prev Next

Use resource link columns to include hyperlinks that go to specific workbooks or worksheets.

To configure a resource link column:

  1. In a worksheet, select Column and KPI Settings, then select the Columns tab.

  2. Select or create an input column.

  3. In the Column settings dialog, go to the General tab.

  4. In the Value type or Type dropdown list, select Resource Link or RESOURCE_LINK.

  5. Select Save. Two additional hidden columns are automatically added to the worksheet:

    • Link: Name WB ID
    • Link: Name WS ID

    where Name is the name of the newly created resource link column.

  6. Show the Link: Name WB ID and Link: Name WS ID columns.

  7. In the resource link column, double-click the field in the needed row and enter the hyperlink text.

  8. In the Link: Name WB ID column, double-click the field in the same row and enter the ID of the workbook where the hyperlink should redirect users.

  9. In the Link: Name WS ID column, double-click the field in the same row and enter the ID of the worksheet where the hyperlink should redirect users.

    Note

    A hyperlink won't appear unless you enter a workbook ID.

  10. Hide the Link: Name WB ID and Link: Name WS ID columns.