I am using functions like FILTER or QUERY to bring data from one sheet to another.
=QUERY(Data!A2:$D, "SELECT B WHERE C = 'fragment' ") =FILTER(Data!E2:E, Data!C2:C = "fragment")
Is it possible to bring the link reference to the printed cell or row to be able to navigate to that?
It is seems that I had to turn the column text values into hyperlinks like that https://docs.google.com/spreadsheets/d/id/edit#gid=123&range=XYZ.
Do you have any ideas? May be I had to use app script for that?