link from sheets to other data object

Unless I’m doing something wrong, my attempts to link from items in a Sheet to another file, a .rtf or .txt file, will not work at all.

This would go a long way toward making sheets more useful to me. I’d like to be able to associate an item of a record (or two) with another page of notes, for instance, but still be able to sort the collection of records and view the main dataset in a spreadsheet-like list.

It’s not currently possible to use a hyperlink within a Sheet, because Sheets use plain text.

I have a workaround. If the Sheet contains the Name of a document within the database, select that Name and press Command-/ (the Lookup Service). A Search page will be opened with the Name already inserted. Do a Name search and the target document will be in the search result.