Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-spreadsheets]

Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

0
votes
0answers
5 views

Google Sheet - List values if cell contains partial value

I'm having a ton of trouble getting an array to work. I'd like to search a "Tags" column on Excel to see if it contains a certain phrase (some rows might have multiple tags listed and separated by ";")...
0
votes
0answers
11 views

google-spreadsheets show insignificant zero [migrated]

I want, when I write a Number in a Cell, that the zeros are still visible. In a Google sheet. e.g. when I write 1.050, or 1.0 or 1.2000 there should stay exactly that. Not 1.05; 1; 1.2 or something ...
0
votes
0answers
7 views

How to alphabetize all worksheets in a Google Sheets project

I am trying to alphabetize all worksheets within a Google Sheets project (there are around 150 worksheets in one project.) I have tried the following script, but it places the worksheets in random ...
0
votes
1answer
10 views

How to automatically create multiple sheets on Google Sheets?

I have one sheet (Sheet1) which I consider the template. In it I have a header with fields like "Student's name", "Parent" and "Phone number", which are personal info. Bellow it there's other stuff ...
0
votes
0answers
10 views

google sheets javascript filter multiple sheets based on dropdown filter [on hold]

I am working on a user access review spreadsheet with multiple tabs of different user listings. I have the main tab called 'Mgr Selection' which I would like the manager to select their name from a ...
0
votes
0answers
7 views

Fetch Data from Google spreadsheet and show it on website [closed]

Dear superuser community, I have a google-spreadsheet and multiple users who can edit this table. The main purpose is to allocate people to different projects. The users can edit when they would like ...
0
votes
0answers
7 views

Imported values in G sheets from G Forms [migrated]

Using G forms for a quiz... The quiz is graded /30 Value is transmitted into G sheet doc. Cell C2 displays value of grade...here, 14/30 (as an example) Value for cell C2 reads as 14 Attempting to ...
0
votes
0answers
5 views

Is it possible to create a chart mapping two columns to each other? [migrated]

I have a sheet that contains a list of books, with metadata about those books. Two columns that exist are the library within which the book is stored, and the condition of the book. I'd like to create ...
1
vote
0answers
20 views

I want to push either a TSV file or JSON up to a Google Sheet

I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows: A: The unique key for ...
0
votes
0answers
4 views

IF Statement not working in google sheets? [migrated]

So I'm using Google sheets and I'm trying to determine whether or not cells in certain column (AO) have a higher value then cells in another column (O). My formula is IF(AO6 > O6,"UNDER","OVER"). The ...
0
votes
0answers
12 views

How do I save the format of chart I created in Google sheet

I have a chart in google sheet that I format to look more appealing to myself. This formatting includes changes to font size, font color, etc. (the usual prettifying knobs of any chart). But how do I ...
0
votes
0answers
3 views

Google Sheets Data Validation Sheet 1 from Sheet 2 App Scrips [migrated]

Im trying to figure out how to validate data entries in one column on sheet 1 from a database I created in sheet 2. In column A sheet 1 the user is allowed to type in a string, upon completion it ...
0
votes
0answers
10 views

Assigning value to words, then adding the words at the end of a row

So I'm trying to figure out how to assign a value to a word, and then put those words in a table, and sum the words at the end of a row. Example: Rarely = -3 Occasionally = -1 Often = +3 here's an ...
0
votes
0answers
19 views

Excel online editing - how to set privacy?

I'm using excel online to create a document that allows individuals to plug in their information. For example a list of classes that individuals can sign up by putting their names next to. Is it ...
0
votes
0answers
7 views

Google spreadsheet, Compare dates from two years in a graph when dates not identical [migrated]

I cant figure out how to compare two data sets with date intervals form each year. Only the start and end date are same day the rest is spread over the period. and there ca nbe more points in one ...

15 30 50 per page