Ben Collins Profile picture
Aug 23 β€’ 12 tweets β€’ 8 min read
πŸ”₯ AMAZING SPREADSHEETS πŸ”₯

To some, Google Sheets is just a humble piece of work software...

...but to others, it's a blank canvas to build incredible things with.

10 creations you won't believe are built with #GoogleSheets:
1) Wordle in Google Sheets, by @aTylerRobertson

Tyler builds amazing games in Google Sheets, using only the built-in formulas.

His wordle game is just one of many:

πŸ‘‰ zapier.com/blog/wordle-in… Image
2) Minesweeper in Google Sheets, by @KieransSheets

This is a beautifully constructed game that uses Apps Script (Google Sheets code) to recreate the classic minesweeper actions.

Kieran has documented the build in amazing detail too!

πŸ‘‰ kierandixon.com/google-sheets-… Image
3) Monopoly in Google Sheets, by @FrancysDong

πŸ’΅πŸ›–πŸšοΈπŸ‘€

A very playable version where users actually move their shapes around the board, reminiscent of the actual game.

πŸ‘‰ francysdong.itch.io/monopoly-at-go… Image
4) Etch-A-Sketch in Google Sheets, by yours truly (@benlcollins)

Play the classic drawing game in this Sheet, built using only formulas.

πŸ‘‰ benlcollins.com/spreadsheets/e… Image
5) Digital clock in Google Sheets, by @RobinLord8

A cool example of conditional formatting and the NOW() function!

πŸ‘‰ therobinlord.com/making-a-digit… Image
6) Analog clock in Google Sheets, by @benlcollins

Following on from the digital clock, here's an analog version built using only formulas. The sparkline formula creates the clock.

πŸ‘‰ benlcollins.com/spreadsheets/g… Image
7) Happy Birthday Formula in Google Sheets, by @xkcd

One of the most elaborate, skillful, and complex ways I've seen to wish someone a happy birthday! πŸ˜‚πŸ₯³πŸŽ‰

πŸ‘‰ Image
8) Deep Neural Net in Google Sheets, by @_blakewest

Ok, you're not going to start doing ML work in Google Sheets, but this is a seriously impressive explainer.

You can literally see each step of the process in the Sheet.

πŸ‘‰ towardsdatascience.com/building-a-dee… Image
9) Party in a Google Sheet, by @tigershungry

πŸŽ‰πŸ₯³ πŸ™Œ

So creative!

An amazing example of collaboration in #GoogleSheets

πŸ‘‰ onezero.medium.com/party-in-a-sha… Image
10) Chocolate bar chart, by @max__makhrov

Max is a super talented Google Sheets developer.

He built a "chocolate" bar chart with formulas and conditional formatting and it's completely bonkers!! (In a good way πŸ™ƒ)

πŸ‘‰ Image
And that's a wrap! πŸ‘

Super inspiring to see such diverse inventions come to life from nothing but a humble spreadsheet.

Any Sheets you'd want to add?

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Ben Collins

Ben Collins Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @benlcollins

Aug 24
🚨🚨 BREAKING: 🚨🚨

If you're a Google Sheets user, stop what you're doing and check this out...

...they just dropped 10 new functions on us!!! πŸ”₯πŸ”₯πŸ”₯

Christmas came early for Sheets nerds πŸŽ…

Let's check them out πŸ‘‡
1/ NAMED Functions

Named Functions in Google Sheets let you save and name your own custom formulas and then re-use them in other Google Sheet files.

This reusability is a HUGE development. I'm SUPER pumped on this one.

E.g. here's a function called STARCHART that I created:
2/ LAMBDA Function

It's here!!

The LAMBDA function in Google Sheets creates a custom function with placeholder inputs, that can be reused.

Used with other lambda functions (see below). Image
Read 12 tweets
Aug 8
The SEQUENCE function is an amazingly useful function in #GoogleSheets. It lets you create sequences of numbers from a single formula. The obvious use case is to create a count up 1, 2, 3, 4, 5 etc.

But did you know you can easily create a count down in your Sheets too? πŸ‘‡
This single, simple formula:

=SEQUENCE(100,1,100,-1)

counts down from 100 e.g. 100, 99, 98, 97, 96...1

To count down from some other number, for example 50, change it as follows:

=SEQUENCE(50,1,50,-1)

Easy-peasy!
The four numbers you enter as arguments to the SEQUENCE function represent:

βœ… Number of rows (e.g. 100)
βœ… Number of columns (e.g. 1)
βœ… Start number (e.g. 100)
βœ… Step to increase/decrease by (e.g. -1)

Arguments 2, 3 and 4 are also optional.
Read 4 tweets
Aug 1
If you create #GoogleSheets that multiple people use, one super helpful thing you can do is add a sidebar to your Sheets, containing key info or instructions.

Today I'm going to show you how to create sidebars using the group columns feature...
STEP 1️⃣

Highlight some columns, right click, and choose Group columns.

This adds a button above the columns, which you can toggle to show/hide these grouped columns.
STEP 2️⃣

Right-click on the +/- button and select left or right to set the +/- toggle button to be on the left or right of the group.
Read 5 tweets
Apr 8
Today I want to show you a quick way to add an ID column to your #GoogleSheets tables, using the SEQUENCE and COUNTA functions.

It's a quick way to see how many records you have in your table.

Let's go! πŸ‘‡

(1/9)
We need a dataset for this example so let's grab an education dataset...

Here are some student test scores along with some variables that affect those scores.

(2/9)
Insert a new blank column on the left of this dataset. Add the title "ID" in cell A1 and this formula in cell A2:

=SEQUENCE(COUNTA(B2:B))

(3/9)
Read 9 tweets
Apr 7
Did you know you can publish your #GoogleSheets as web pages?

You can then share these web pages with the world, so people can see your Sheet as a distinct, lightweight webpage.

It's a good idea if you want to show the Sheet to a very large audience.

(1/3)
Here's an example:

docs.google.com/spreadsheets/d…

(2/3)
And here's how to do it:

1️⃣ Go to File > Share > Publish to web.

2️⃣ On the popup, select the Sheet (or Sheets) you want to publish and hit Publish.

3️⃣ Share the URL wherever you want!

There's even an option to embed the Sheet within an existing web page. πŸ˜ƒ

(3/3)
Read 4 tweets
Apr 6
Yesterday I introduced the QUERY function using this formula:

=QUERY(A1:E100,"select B, D, E where D = 'Europe'",1)

It returns only columns B, D and, E, and only rows where column D is equal to "Europe."

Today's question: How can we change "Europe" to a certain cell, like G2? Image
Well, if you try to put the cell reference straight into the select statement it won't work, because the select statement is a text string.

Also, Europe is surrounded by single quotes, and these need to be included even when we reference another cell.

πŸ€”
To reference another spreadsheet cell, we close the text string, reference the cell, and then open the text string again.

What the...?!
Read 6 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(