All Questions
11 questions
0
votes
0
answers
25
views
Google Sheets Scripts: How can I select a range of values and apply a new unique value to each cell?
I'm sure this has been asked to death and I've done some experimenting myself with trial/error. I'm novice-level with coding, so I'm sure the way I've gone about it is very archaic and messy.
I'm ...
1
vote
0
answers
37
views
Is there a script that can create links on all cells from a list and once you click on them to send you to the respective (same named) tabs?
I have a list with 10 items and have created 10 tabs named from those 10 items. Is there a script that can creates links on the List Name cells and once you click on them to send you to the respective ...
- 79
2
votes
2
answers
9k
views
How to get/extract the link and text of a Google sheet cell? [duplicate]
Can we get the text and link URL from a cell created in a Google sheet and save the result using either a formula or script into 2 cells: text and URL?
1
vote
1
answer
601
views
G Sheets Table of Contents Script
For Google sheet workbooks that have several sheets, I create a Table of Contents sheet that lists all of the sheets in the workbook to increase ease of use for users.
I have looked for an add-on, ...
- 173
3
votes
0
answers
1k
views
Is there a custom function or script that returns gid of a specific sheet in Google Sheets? [duplicate]
I have been poring through the vast sea of knowledge on the Internet to get what I need but to no avail.
Context
In a single Google Sheets file, I have one master sheet and various other sheets ...
- 77
1
vote
1
answer
3k
views
Generate URL for each sheet from a list of tab names [duplicate]
Google Sheets question here. Suppose I had a column in my workbook where each cell contained the name of a tab in the workbook. Is there a way (formula or script) to generate a column that contains ...
- 11
0
votes
2
answers
70
views
How to Retrieve data from a Google Spreadsheet File to another and put hyperlinks?
I have 2 workbooks on Google Drive, WB(A) - 10 different sheets and WB(B) - only one sheet.
I want to retrieve some data from certain cells from WB(B) from every sheet to store and update at WB(A), i....
- 73
1
vote
1
answer
2k
views
Google Sheets: count numbers of HYPERLINKS where value > 0
I have a range of cells in Google Sheets
Some of these cells contain values (numbers) some with and others without HYPERLINKS
I need to count the number of hyperlinks for this range of cells if the ...
- 27
2
votes
0
answers
504
views
How to automatically duplicate hyperlinks so that it links to the same duplicated page and not the original in Google Sheets?
I have a long table with sections in a Google Sheets sheet. The first four rows are frozen and have hyperlinks to all the sections in the table so I can access those sections fast. I need to create a ...
- 23
21
votes
4
answers
24k
views
Apps Script: how to get hyperlink from a cell where there is no formula
I have a sheet where hyperlink is set in cell, but not through formula. When clicked on the cell, in "fx" bar it only shows the value.
I searched on web but everywhere, the info is to extract ...
- 523
19
votes
2
answers
33k
views
How to insert hyperlink to a cell in Google sheet using formula?
I am trying to insert a hyperlink to a cell in a fashion that can be replicated using '=MATCH()" function. However, I can't seem to figure out a method to link a cell in Google sheets without ...
- 248