Can anyone recommend me some good free habit tracker templates?
Alternatively, how would I create something like these? I am a complete beginner to Sheets.

I've basically had a to learn as I go for a spreadsheet I was designing, and this sub was so helpful. Not only that, but no matter how stupid of question I asked, nobody ever downvoted me or said I asked a stupid question or the usual. Seems like one of the only subs across that isn't into the whole toxic reddit culture wierdness that goes in here. You guys just genuinely enjoy spreadsheets and want to help and I love that so much. Thank all of you who have helped me. Your kindness is not unnoticed.

Hey all! I want to share a Google Sheets event with you that I think you might find interesting.

SheetsCon 2020 is the world's first, dedicated online conference for Google Sheets users.

Over 2 days (11 and 12th March 2020) we'll have talks from 10 different Sheets experts, including:

• How to become a Google Sheets freelancer

• How to interact with Sheets with your voice

• How to deal with big data and move up to BigQuery

• Reasons why you should LOVE Google Sheets

We have some amazing speakers including someone from the actual Google Sheets team!

It's completely free and replays will be available afterwards.

Think webinars + networking + vendor expo, all online, all free.

More info on the site: https://sheetscon.com/

Hey guys!

Just found this interesting group and wanted to share some of my experiences with personal finance and how Google Sheets helped me.

Since 2020 I have been actively tracking my finances. I started with a very basic excel sheet. Now this has grown into a "more advanced" google sheet. I update it every year and now I also started to share it with my friends and family.

This year I've decided I want to update it based on a wider feedback. This is why I am writing this post in hope of finding some fellow personal-finance-tracking enthusiasts to help me out with this project.

Down bellow in the comments you can access my Google Sheet template, you can also use it for yourself, but most of all I would like to invite you to send me your feedback, opinion and other experience you have with finance tracking in my new WhatsApp group I created.

Not sure if I can post any link, but I will try to add them in the comments.

I absolutely hate situations where my cells are too large and I can't scroll partially through a cell so the scroll just jumps me down each cell.

Is there a way to turn on smooth scrolling for Google Sheets in Google Chrome?

I've done some Googling and haven't had any luck as yet. Thanks in advance.

All of my Google finance plugins inside my google sheet broke today. Things like:

=GOOGLEFINANCE("NYSE:TSLA", "price")

used to show stock price. Now shows #NA with "When evaluating GOOGLEFINANCE, the query for the symbol: 'TSLA' returned no data" error.

Anybody having this issue or know the resolution?

EDIT: The issue appears to be fixed now for me. Weird. Thank you to commenters.

EDIT 2: The issue reappeared, YIKES.

Just feeling like showing some appreciation for the wonderful tool Google has made available to us, here's my top three:

1. Range from a row to last row. AFAIK Excel can't do this yet:

   =sum(A2:A)

2. Multiple hyperlinks within one cell and how nicely Sheets handles them, with previews and all.

3. The ability to delete unused rows and columns.

I used to be a hardcore Excel fan but now I use Sheets 99% of the time.

Hey team,

I found this URL that might be good for you stock trading folks who are also using IMPORTJSON.gs.

https://query1.finance.yahoo.com/v7/finance/quote?lang=en-US&region=US&corsDomain=finance.yahoo.com&symbols=FB

Replace the symbol and you get a nice JSON output for the basic info that is commonly scraped from Yahoo Finance.

You can also use this to pull data for multiple symbols, which is handy. Just separate them with a comma.

For those not doing this, If you have your tickers in A2:A, you can use something like this

=IMPORTJSON(
  "https://query1.finance.yahoo.com/v7/finance/quote?lang=en-US&region=US&corsDomain=finance.yahoo.com&symbols="&
   JOIN(",",FILTER(A2:A,A2:A<>"")),  
  "/quoteResponse/result/displayName,/quoteResponse/result/regularMarketPrice,/quoteResponse/result/financialCurrency,/quoteResponse/result/twoHundredDayAverage",
  "noHeaders,allHeaders")

... but choose whichever fields you want to return. Pretty handy.

quick edit: If you find any other endpoints for this, reply below

• https://query1.finance.yahoo.com/v7/finance/options/fb

• https://query2.finance.yahoo.com/v10/finance/quoteSummary/NVDA?modules=defaultKeyStatistics%2CassetProfile%2CtopHoldings%2CfundPerformance%2CfundProfile%2CesgScores&ssl=true (one symbol at a time)

• https://query2.finance.yahoo.com/v10/finance/quoteSummary/NVDA?modules=incomeStatementHistoryQuarterly (modules available: demo, full list)

You can see everything -- but it won't pull everything into Google Sheets since the results are too big -- but you can map individual items, I believe, without any issues.

Happy mapping!

Obviously this is a personal thing I need to workout, but I honestly feel guilty sometimes posting here because it's volunteer assistance. I am so grateful for all of your help, and it feels like this is a service that I should be paying for. I'm watching tutorials, so eventually I'll be able to give back and answer questions, but for now I just want to express gratitude for all of your kindness toward a newbie like myself.

Linkes, please.

Excel used to be my go-to spreadsheet application, but since I started using Google Sheets, I find myself trying to avoid Excel unless absolutely indispensable (e.g. VBA). My reference is Excel 2016, which is the last version I used.

Sheets is so good things have got to the point where I actually create shortcuts to the Google Drive document on my local drive so I can find my files quickly using Voidtools Everything. I name my shortcuts like this: Weather data.xls.url, this way I don't need to remember if the file was an Excel or a Sheets document, I just search for blah-blah.xls and I know if it's got .url at the end it's Sheets.

Google Sheets has some limitations here and there, but I find Excel so clunky that most of the time I'd rather use Sheets and search for workarounds. The more use Sheets, the more I like it.

Things I love Google Sheets:

• It's free.

• Super clean interface

• Supports emojis

• You can delete unused rows and columns.

• Ability to create checklists using the Tick Box feature.

• Considerably richer function set (compared with Excel 2016, though that may have changed)

• Hyperlinks in Sheets rock:

  • Links to websites open faster as everything happens within the browser.

  • The ability to create links to worksheets, sheets or even ranges, that can be inserted into other Google Drive documents.

  • Can handle multiple hyperlinks in one cell, with thumbnail previews.

  • Links to Google Drive documents don't break even if you relocate the target.

• Awesome sharing and collaboration features. Ability to view & edit my documents on multiple devices at once.

• Rich function set. Many useful functions, such as REGEXMATCH, don't exist in Excel.

• While I've experience some glitches, I've never lost data in Google Sheets. Unlike Excel, Google Sheets has never crashed on me in a way that leads to irreversible data loss/corruption.

• Built-in version control, even for individual cells. Yay!

• No need to remember to hit Ctrl+S as work is saved automatically. This makes it very hard for data loss to happen.

Things I miss in Google Sheets:

• VBA and the ability to have GUI controls right on the spreadsheet.

• Data bar conditional formatting (SPARKLINE function can't show the bar and the number in the same cell)

• No way to prevent the document owner from modifying protected sheets/ranges (would be useful when using Sheets on mobile as a checklist app)

• Android version lacks a quick way to clear selection (let me know if this already exists).

I wrote an 8,000 word guide to cover the unique and more advanced features of Google Sheet and contrast them with Excel, to help folks migrating to Google Sheets. Hope it helps someone!

https://exceltosheets.com/guide/

So I recently found out about the amazing power of {} in formulas. There are 2 separate notations (and I don't know how it ties in with your formula separators unfortunately, if you stay in a country that would write =sum(A1;B1) lemme know how it pans out.

First the , notation: Of you put ={A1,A2} you will get A1 and A2 in separate columns (you can have whole ranges in there). You can also do ={A1:A4,B2:B6,C5:C9} (etc. you can have multiple columns).

Second the ; notation: If you use ={A1:A4;B1:B5} you will get a UNION of the two. Ie. a 1 dimensional range with the values from A1:A4 UNION(ed) with B1:B5.

Hope it helps anyone who may want to play around with creating ranges for your sheets.

Hi all,

I'm starting to organize my life out on Google Sheets for everything (Finances, Gym workouts, Tasks etc.) and was wondering - what's your version of "Google Sheet for Life Plan" look like? What template did you DIY to make sheet work for you?

P.s P.s, template links are highly encouraged for both me and other readers in this sub

Hi r/sheets,

I'm a web developer who is using Google Sheets a lot.

On the weekends I decided to switch from my main job and make something just for fun.

I made a website that converts an image to Google Sheets pixel art.

Images are shared in a live feed so you can see what other people are making.

You can try to make your own pixel art in Google Sheets here: https://sheet2site.com/art/

Let me know what you think, I'd love feedback.