+ Reply to Thread
Results 1 to 3 of 3

Google Sheets AppScript - Add custom link to retrieved value.

  1. #1
    Registered User
    Join Date
    04-23-2007
    Posts
    31

    Cool Google Sheets AppScript - Add custom link to retrieved value.

    On my 'Orders' worksheet, I am using some script to populate the Item column based on the chosen Style value.

    EXAMPLE GOOGLE SHEET

    Double click any empty cell in the Style column choose CODE 3 - the Item column will automatically populate with ITEM 3. It retrieves this data from the 'Styles' worksheet.

    I am also storing a single URL for each item. When the script runs and populates the Item column, I would like that value to be clickable, and point to the URL stored in the 'Styles' worksheet.

    So in the above example, everything would work the same - but Item 3, if clicked, would open www.item3.com

    I'm wondering if this is at all possible.

    Thank you in advance for any help.

  2. #2
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: Google Sheets AppScript - Add custom link to retrieved value.

    Hi antonyx,

    on the Orders sheet, try changing the formula in cell K1 to the following:
    Please Login or Register  to view this content.
    Screen Shot 2022-04-23 at 12.40.58 am.png
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    04-23-2007
    Posts
    31

    Re: Google Sheets AppScript - Add custom link to retrieved value.

    That's awesome, works perfectly and the formula makes perfect sense.

    Thank you so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA - google search and link first google hit
    By GreGor1111 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2022, 08:43 AM
  2. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  3. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  4. Convert VBA" IF THEN" function into Google Appscript code
    By frnzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-19-2019, 01:52 AM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. [SOLVED] Five individualy link-shared Google Sheets into One-how
    By Red fuji in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-13-2015, 12:18 PM
  7. Populate a cell with URL retrieved from Google?
    By camfrye in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2008, 09:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1