A computer application that simulates a paper accounting worksheet.

learn more… | top users | synonyms

2
votes
2answers
93 views

Split text with Google spreadsheets

I have a Google spreadsheet with 1,500 cells containing items like: 1,300 users 2236 users, 12 companies 15000 users,153 companies <46,000 users, <200 companies I need to split this ...
1
vote
1answer
57 views

Spreadsheet: function to watch row for changes

Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
1
vote
0answers
23 views

Send email from Google Spreadsheet to adress in column

From an existing Google Spreadsheet; every time a value is added in column M(x), I would like to send an email with a specified text to the adress listed in column F(x) from the same row x. Which ...
1
vote
0answers
43 views

Can't unmerge cells

I have a lot of data on a google spreadsheet that depends on charts I spent ages trying to make look pretty. There is a stupid block of merged cells that won't unmerge, and when I try to cut'n'paste ...
0
votes
0answers
8 views

How to contour data from a google spreadsheet?

Google has a lot of cool things such as Spreadsheet Mapper, Fusion Tables, and Google sites. I have a google spreadsheet with data in the following format: latitude, longitude, humidity How would I ...
0
votes
0answers
8 views

Sum of dynamic number of values derived from fomula in Google spreadsheet

In short my question is this. If I use the SUM function (or some other function) that can take one or more arguments, is there some way I can pass in these arguments as an array which varies over some ...
0
votes
0answers
7 views

Google spreadsheet to open another Google spreadsheet populated

What I would like is to click on a name in a cell in one spreadsheet and it will populate a new spreadsheet giving the title in ascending order such as A001 next time you click it it will populate a ...
0
votes
0answers
87 views

Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...