Tagged Questions
One of productivity apps in Google Drive, that allows you to create and edit worksheets
-1
votes
0answers
5 views
In Google Drive spreadsheet, how do I put tabs at the top of the screen?
I want to make a public Google Doc with tabs similar to https://docs.google.com/spreadsheet/pub?key=0AifXEOqTcGcLdFVvWk1GRjVJTHJUaTVLcGViR1RRTFE, but I haven't been able to find instructions or other ...
0
votes
0answers
13 views
How do I sort forms individually based on individual events in Google Forms?
My purpose is to conduct 5 events, namely 1,2,3,4,5 say ...
I'm using a Google form to accept responses from people. Emails are sent to people automatically and they can register for more than 1 ...
0
votes
0answers
8 views
Grouping Pivot Table Date Settings Into Weeks or Months in Google Spreadsheets
In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select 'group' (from the drop down menu) - then you can choose different groupings, ...
1
vote
1answer
11 views
How many named ranges can a single Google Spreadsheet have?
Is there even a limit to the number of named ranges that you can create within a single Google Spreadsheet?
It's rather cumbersome to add a new one, so I would prefer to not just open a spreadsheet ...
1
vote
1answer
11 views
Google Drive spreadsheet - create chart with total for each score
I have a column within a google spreadsheet with values like this:
96
97
96
100
97
97
100
97
95
95
96
I'd like to add a bar chart where each bar represents one of the values and the height of the ...
2
votes
1answer
17 views
Place cell data from a Google Spreadsheet into a Google Document
I'm trying to populate an invoice.
I have a Google Spreadsheet that calculates hours per project, and I want to bring that into a Google Document, but despite much searching, have found no way to do ...
0
votes
1answer
7 views
Google Sheets, Suddenly decimalised some of my number entries
Hi I've been using google sheets to create a record of car parts entering each parts serial number, the amount of that particular part, the name of the part and the location I'm storing the part. I ...
0
votes
0answers
6 views
Stacked area graph of time/duration values
How can I create a stacked area graph of time/duration values?
I have a set of times for each date which correspond to each leg of a journey.
...
0
votes
1answer
25 views
Importing Columns of Data
I'm trying to import columns of data from different sheets. Examples
SEARS -- (sheet one) (I'm entering the prices manually)
1/2013 $8
2/2013 $5
3/2013 $14
Here is sheet two: (I'm entering ...
0
votes
0answers
6 views
Compare two rows of a sheet to another and show characteristics
I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products ...
0
votes
0answers
14 views
Import Range on Google Spreadsheet
I want Cell D1 of this link:
https://docs.google.com/spreadsheet/ccc?key=0AupKcedJ0nhPdFFyMVhySWNvNzlYTV9RZ1FmYXdKc0E&usp=sharing#gid=2
To be imported to E9 of this link:
...
0
votes
0answers
8 views
Find items that are not duplicates Google Docs
I have these cells A1 through A7:
Mary
Susie
Jane
Mary
Susie
Elizabeth
Mary
I want to get the names that do not appear multiple times, so my results should be Jane and Elizabeth. I don not want ...
1
vote
0answers
14 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
0answers
24 views
COUNTIF and data validation in Google spreadsheet
I'm new to using Google Spreadsheets and I'm trying to make a Count if function. What I need it to do:
If the data validation in cell D4 is "Tora", count amount in cell C4.
I don't even know where ...
0
votes
0answers
14 views
Add Drop Down Boxes into total
I'm trying to style this sheet better so a user can select items from Everquest Next Landmark and get a total of all the items needed to craft it all.
Basically if they want to add up a copper ...
