Part of the Google Docs suite, a web app that allows you to create and edit worksheets
1
vote
0answers
19 views
Looping through the range of cells to test the dates
I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match.
It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
3
votes
0answers
20 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
3
votes
1answer
44 views
Conditionally format by day of the week
How can I conditionally format cells in Google spreadsheets containing dates to have a different background according to the day of the week, e.g highlight the Saturdays and Sundays in a column ...
3
votes
2answers
29 views
How to sort a sheet in Google Spreadsheet by multiple columns?
Having a table with data like:
- + + -
- - - -
+ + - -
where + and - are created via '-, '+ commands, How to sort it recursively (probably other word shall be used) meaning sort ...
2
votes
1answer
44 views
Conditional formatting based on cell values in same column
In Google Spreadsheet, how do I change a cell's background color to red if the date in the cell matches the date in another cell in the same column? Column E in my spreadsheet is a list of due dates ...
1
vote
0answers
39 views
How to do a date formula in Google Spreadsheets
I have to do a query that increments automatically the date year by year. For example I use this formula:
=INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
1
vote
1answer
55 views
Stop content from making cell two lines
In Excel if you have a long piece of text like a URL in a cell you can stop the cell from becoming a double-line cell and messing up the rest of your layout.
It does this by just clipping the info ...
1
vote
0answers
46 views
how to make Google Docs spreadsheet recognize data as numeric
I have the opposite of a fairly standard problem -- how do I force Google Docs spreadsheet to understand that a value is numeric?
It seemed like using Format > Number should do the right thing, but ...
1
vote
1answer
36 views
Problem QUERY function in Google Spreadsheets formula
I tried this formula:
=concatenate(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')";0))
The result is ...
1
vote
1answer
37 views
Iterated variable (i) for argument on range in Google Scripts API
for (i=0; i<numItems; i++) {
var cell = sheet.getRange(12,i);
cell.setFormula(i);
}
This simple formula should go to every place on the column 12 where there is data, and replace it ...
1
vote
1answer
17 views
Share individual copies of a Google spreadsheet
I created a Google Spreadsheet file which I want to share with my coworkers so each one has his own copy. So far the only way I found is to share the file, however these doesn't work for me because ...
2
votes
1answer
54 views
“Yes” if a value partially matches in a range of values, blank otherwise
I have a column of values (column A for this example) like such:
Phytophora sojae
Phytophora ramorum
Cryptococcus neoformans
Coccidioides posadasii
And I'd like to create a new formula column (B) ...
-1
votes
1answer
43 views
How to use multi-line text in Google Spreadsheet?
When I try to enter multi-line text, I see void cell as fast as I leave a cell. How can I overcome this?
2
votes
1answer
41 views
Google Spreadsheet Sort Two Columns
So I've found the following answer in regards to auto-sorting by one column, which works great
How can I make some data on a Google Spreadsheet auto-sorting?
However, my use case requires the sorting ...
1
vote
0answers
30 views
delay in updating referenced cells when using importrange in google drive
Im using the importrange() function in Google drive to reference data from 'spreadsheet1' and display in it 'spreadsheet2'.
This works fine, but 'spreadsheet1' and then go to 'spreadsheet2' its not ...
