As stated in the tittle I'm trying to make the content of a cell that links to an other cell have it's display text be based on the other cell's content. Before I was able to do it by right clicking the cell and adding a link using the button (which would generate something that looks like
But earlier this year it looks like Google sheets has been updated and this no longer works. Now I only figured out how to either have a link on a cell or have text equal to an other cell's text but never managed to figure out to have both at once on the same cell.
A1 has "Hello i'm a cell living in this world"
What I would like is having Cell
B1 linking to
A1 but also display "Hello i'm a cell living in this world" (exactly
How can I achieve this?