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
1answer
74 views

Date format in Google spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format-number-more formats-more date and time formats, and I changed it to day-month-year. And ...
2
votes
2answers
90 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 ...
0
votes
1answer
83 views

How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
2
votes
2answers
50 views

How do I merge cell data into a new column?

A | B ----- 1 | a 2 | b 3 | c and I'd like to have a third column that merges the data like this: A | B | --------- 1 | 1, a 2 | 2, b 3 | 3, c currently I can kind of do this one row at a time ...
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 ...
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
1answer
97 views

Google Sheets: Find the maximum occurrence across sheets

This is kinda difficult to explain... Is it possible to let Google Sheets tell me what the maximum value is from some chosen coloumns in MORE THAN ONE sheet (in the same document)? I namely need to ...
0
votes
1answer
1k views

Password protected online database or spreadsheet

I have a client that wants a simple online database or spreadsheet solution. Requirements Custom fields and field types (text, images) CRUD contents through a web GUI Password protected (single ...