So I have a formula that has a hyperlink and an importrange associated with it... so the cell where the link and formula is, shows the entire formula in the cell... I'd like for the cell to say "Box" instead of having the entire formula show. How does one do this?
This is my formula
=iferror(HYPERLINK("https://docs.google.com/spreadsheets/d/1bPvWRCmrR_yUyQqyca5wpfCoNozKJNJLkkbI9ULpmh8/edit#gid=822632151&range=A" & MATCH(C3, IMPORTRANGE("https://docs.google.com/spreadsheets/d/1bPvWRCmrR_yUyQqyca5wpfCoNozKJNJLkkbI9ULpmh8/edit", "Boxscores!A:A"), 0)),"")
Thanks for your help.
Bookmarks