Super User Stack Exchange
Super User 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.

Google Sheets (formerly Google Spreadsheets) is part of the Google Docs Editors suite of office tools.

See our sister Stack Exchange site, Web Applications for more focused questions and answers on Google Sheets and other Google Docs Editors applications.

474 questions
68
votes
1 answer

How to convert a duration into a number of hours in Google Spreadsheets?

Trying to organize a timesheet. I have a cell with a duration of, say, 84:30:00 (84 hours, 30 mins, 0 seconds), which has a number format of "Duration". How can I calculate the decimal number of hours (84.5) from this? The obvious approaches Hour(),…
Athena
  • 1,793
52
votes
3 answers

Pad numbers to specific length in Google Spreadsheet

I have a column with integer numbers like this: 1, 2, 3, 4, 5 and I want to create another column with these values padded to length of three like this: 001, 002, 003, 004, 005. Is it possible to pad string to length in Google Spreadsheet? I wasn't…
Slava Fomin II
  • 831
18
votes
1 answer

Smooth Scrolling in Google Sheets

Google Sheets currently scrolls by entire rows and columns, which can be a jarring experience (especially if there are large rows or columns). Anyone know how to make the scrolling smooth? Fixed as of 3/4/2024! Thanks to @Mintvbz for pointing out…
vancy-pants
  • 289
5
votes
3 answers

How to freeze more than 5 column in google spreadsheet?

How to freeze more than 5 column in google spreadsheet?
metal gear solid
  • 8,914
5
votes
1 answer

Remove line breaks within cells in a range (\n) by Google Apps Script

In a Google Spreadsheet I would normally do the following: Go to Find and Replace Check "regular expressions" Find \n and replace with null I have searched and for the life of me I'm unable to find a Googl Apps Script that I can use to do this…
WtfgJFnaSmKqsRh yRzNhUgueEJw
  • 51
4
votes
1 answer

"Array result was not expanded because it would overwrite data"

I'm trying to use Google Spreadsheets but I get this error when an IMPORTXML would overwrite some rows of cells that already has something in them: Array result was not expanded because it would overwrite data In the old Google Spreadsheets we had…
Howie
  • 231
4
votes
1 answer

Conditional borders in Google SpreadSheet

I would like to have yellow borders on cells that are column's maximum as follows: That is, I need to have conditional borders. I understood I should use Google Scripting but I have no idea nor knowledge how to do that, could you help? Note that I…
JKHA
  • 181
3
votes
1 answer

How to convert to insert mode when editing formulas on Google Spreadsheets?

Google Spreadsheet forces you to be in overtype mode whenever you edit an existing formula. The only way out I know is to type gibberish. That is, for how every many characters you want to insert, you type however many gibberish -- while still…
Argyll
  • 616
3
votes
4 answers

How to open google spreadsheet's extra sheets in new window or tab?

How to open google spreadsheet tab in new window or tab?
metal gear solid
  • 8,914
2
votes
2 answers

Google Sheets - How to find penultimate (second-last) non-empty cell in a column?

I have a column that'll have dynamic filled in fields but will be empty for the most part. I want to find the difference of last two values found in a column but nothing I've tried seems to work.
Spongebob Squarepants
  • 183
2
votes
1 answer

How to add IFERROR to long formula in google sheets

Sorry, but I am a beginner to using formula's like vlookup/index/match etc. I have googled a ton of stuff and have been learning a lot but I can't seem to figure out this one thing. I have the formula: =index($C$58:$C$68,match( AVERAGE( …
Teacher
  • 21
1
vote
1 answer

Google Spreadsheet Indirect in a VLookup

I'm trying to convert an Excel spreadsheet into Google, but can't get this VLookup(Indirect)) combination to work. My data sheets are named with a code, for example "fred01", and look like this: ---A--- ----B---- 1] FIELD VALUE 2] Name…
Cylindric
  • 703
1
vote
1 answer

How to make a formula to calculate how many of each unique item are in a column in the last 365 days

I have two columns A:A (dates) and B:B (items) ..... I need to find a formula to calculate how many of each unique item are in column B : B in the last 365 days. In the example the right value in the formula is 2
Guglielmo Lauro
  • 11
1
vote
1 answer

add prefix to a cell in a spreadsheet

I have a cell in a (google)spreadsheet document (let's say L7) where I usually put a numeric value (like, say: "28", "12", "87"...). I'm trying to make a formula that adds a letter in front (or sometime at the end) of these numbers (like this:…
user430416
  • 21
1
vote
1 answer

How to use countif to find specific formulas

I'm using Google Sheet. I have a bunch of =char(10003) to show check marks in some cells. I want to use =countif to count them all. I'm stuck at what to write for the criterion parameter. How can I find specific formulas using countif?
Saeed Neamati
  • 1,763
1
2 3 4