All Questions
Tagged with spreadsheet google-docs
68 questions
0
votes
2
answers
60
views
Request access to Google Spreadsheet file
I am trying to request access to file via API but fail API returns error as a result:
Details: "[{'message': 'File not found: https://docs.google.com/spreadsheets/d/1u...4bcSqdgc/edit#gid=0.', '...
- 1
-1
votes
1
answer
30
views
Modify a value in another spreadsheet by modifying a form
I have a form that i've received ALOT of help on so far and its almost there, the only thing I need it to do now is a way to adjust "Perks" and in turn made adjustments to the value on the ...
-1
votes
1
answer
45
views
Drop down list produces defined range list in an area
I have a drop down list in E8 that has several item categories in it and below the drop down box I have a square B9 to H24. How can I with the Level 3 drop down selection show a defined named range (!...
0
votes
2
answers
64
views
Spreadsheets listing all the values that are not blank in the first row of a different sheet down a single column
I've been struggling with this which what to me seems like it shouldn't be this difficult. I have two checkboxes (Totally different problem) When one is selected I would like to list the nonblank ...
0
votes
0
answers
230
views
My Google Apps script doesn't run on certain devices
I have written a code in Google Apps script and used an onEdit() function to trigger it. The program successfully runs on my PC and on my Android devices. The problem arises when I share the Google ...
0
votes
0
answers
200
views
importXML Xpath query, <div> tags inside <div> in Google Spreadsheet
I'm using Xpath in Google docs to get the text inside <div>. I want to save the text inside <div class="sc-fbNXWD iBmpVC"> in one cell of Google doc spreadsheet, but it shows ...
- 11
1
vote
1
answer
17
views
Is it possible to sum a value if the substraction of two value on the same row equals something?
I'm trying to build a sheet where I can see how much I have to pay each month.
Let's say I have the following table
Current installment (CI)
Total installments (TI)
Installment amount (IA)
1
3
$100
1
...
- 13
0
votes
0
answers
48
views
Google ExportSheetData: Export XML with more than one atribute column
I'm creating a new spreadsheet on Google with some columns for looping by row.
<filme>
<dia>1</dia>
<geral href="file:///F:/Dropbox/Telecine/Filmes%...
0
votes
1
answer
401
views
bulk find and replace with a condition case match and exact match google app script,doc,sheet
Thank you in advance.
I have a sheet with data as follows.
Find
Replace
condition
Page number ten
Page No. 10
match case
Page number 10
Page No. 10
match case
ms
Ms
exact match
I want to find and ...
2
votes
2
answers
3k
views
Google Docs - Convert date into day of the year
Task is pretty simple and I know I could calculate it myself but can't believe there is no dedicated function for it in GDocs already.
Today is 2019-11-28 it's 332 day of the year.
How to get that ...
- 3,296
-1
votes
1
answer
3k
views
Download Google Docs From Links
I have a list of 500 Google Docs links on a spreadsheet. Would like to download all the Google Docs in a one go WITHOUT opening the Google links?
5
votes
1
answer
7k
views
Sum vertically until empty cell on Google Sheets
This is the scenario. I need to get the sum of the values until it reaches a blank cell. After that it should start again calculating the sum after the blank cell. I need to add the fat and carbs of ...
- 325
4
votes
1
answer
12k
views
Google Docs Remove Title and Footer
I'm trying to embed a Google Docs sheet into my website, however, I am having a problem getting rid of the title bar and the footer. I want to just embed a range of cells and nothing else. Does ...
- 145
0
votes
1
answer
60
views
How to get output of today() function as string in google sheet
I want to append quote to the date value which i receive from =today()-1 function.
Expected output is eg. - "30/05/2018"
- 4,542
-2
votes
1
answer
58
views
vlookup or index match give no result
i have a problem with a vlookup and also index&match formula.
First i transpose split and substitute a result from an api call which is in JSON, then i get a list i can use vlookup with, but when ...
- 53