We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Google Drive office apps - can you link between apps?

So let's say i have a folder with a Google Docs & a Google Sheets file in.


I write out a piece in Google Docs & i want a word to when clicked open up a specific Google Sheets file (there'll actually be numerous Docs & Sheets files).


Can this be done? If so then how?

Comments

  • It's not something I have ever tried. I have linked data in a cell to cells in another Google sheet, which uses a link to the other sheet. Possibly this link could be used with text set up as a hyperlink in the Google doc, but I've never tried it.
    Retired at age 56 after having "light bulb moment" due to reading MSE and its forums. Have been converted to the "budget to zero" concept and use YNAB for all monthly budgeting and long term goals.
  • grumpycrab
    grumpycrab Posts: 5,032 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Bake Off Boss!
    edited 23 November 2018 at 12:05PM
    1. create sheet
    2. get shareable link to sheet
    3. in doc insert link with word "whatever" and link that you got at 2.
  • abssorb
    abssorb Posts: 131 Forumite
    Part of the Furniture 100 Posts Combo Breaker
    Google Drive office apps - can you link between apps?

    The answer's in the question really. :D To link between apps, you use the menu option Insert / Link.

    1. Go to the google sheet, copy the URL from the address bar (its web page address).
    2. In the Google Doc, highlight the word you want to click, from the menu choose "insert link", paste in the address from step 1.
  • abssorb wrote: »
    The answer's in the question really. :D To link between apps, you use the menu option Insert / Link.

    1. Go to the google sheet, copy the URL from the address bar (its web page address).
    2. In the Google Doc, highlight the word you want to click, from the menu choose "insert link", paste in the address from step 1.
    I'm lost. Isn't that what post #3 said?
  • I'm lost. Isn't that what post #3 said?
    Essentially yes. So how are you lost? The instructions look quite straightforward to me.
    Retired at age 56 after having "light bulb moment" due to reading MSE and its forums. Have been converted to the "budget to zero" concept and use YNAB for all monthly budgeting and long term goals.
  • So how are you lost?
    I'm lost because i'm wondering the need of repeating it...?


    Though i'm guessing from the way they highlighted my quoted following up with their opening comment - this is probably the reason they replied, since they didn't actually add anything new. They could've just ended with saying "and i'll tell you to do the same as the other guy".
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 352.1K Banking & Borrowing
  • 253.6K Reduce Debt & Boost Income
  • 454.2K Spending & Discounts
  • 245.1K Work, Benefits & Business
  • 600.8K Mortgages, Homes & Bills
  • 177.5K Life & Family
  • 258.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.