1
vote
1answer
1k views

How to query for count of dates in Google Docs?

I have a Google Spreadsheet of line items. One of the columns is a Date field. How can I query (or use a formula) to, for example, get the count of records where the Date field is within February of ...
6
votes
2answers
14k views

Adding one Google Spreadsheet column to a string to dynamically create a URL in the next column

I have a spreadsheet of product id codes that I'd like to turn into links, and from everything I've read, the concat or concatenate functions in Google Docs should work for that, but so far everything ...
0
votes
1answer
1k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
1
vote
1answer
2k views

Validation based on multiple sheets in Google Docs

I have 2 sheets that each contain a column of data that I would like combined and used as a validation list for a column in another sheet. What would the formula look like for this?