Currently the hyperlink function is not supported in Nathean Analytics Spreadsheets, so a workaround has been created.

The workaround is based upon providing 3 fields in the row before the cell containing the hyperlink formula. They must be calculated fields.

Field -1 – URL Field

This is the url which will be used to construct the hyperlink. It should include the query operator “?”.

eg https://www.google.ie/?q=”

Field -2 – Query Field

This is the field which will contain the search value for the query and would normally be a field from the dataset in the normal field notication.

eg ##Available_Rakuten_Files_and_Summaries_UAT##EXPORT_TO_S3

It’s recommended that these three columns are then hidden. Once the hyperlink formula also works in Excel, you have a mechanism for the hyperlink to work in both Excel and Nathean Analytics

Field -3 – Message Field

This is the field which will contain the text which will appear in the label for the hyperlink.

eg =“View Data”

Video Demonstration Below:

Revision: 17
Last modified: Jun 22, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment