- Okay, we're going to be taking a look
at spreadsheet.com and we're going
to be focusing on the things
that you can do in this spreadsheet
that you really can't in Google Sheets or Excel.
Let's take a quick gander at the different worksheets down
at the bottom.
And they have several worksheets
because they're linked together.
So this is a concept that does not exist in Sheets or Excel
but several of these pieces of data
are literally linked to data and other worksheets
and you can go back and forth.
So let's start out at the products.
This first column, if you see this little key next to it
is required, and it must be unique for each row
and that's how each of these records is identified.
And then on these other worksheets,
you can refer to these columns.
So we won't go too far into that concept right now
but that's one of the major things
that makes spreadsheet.com different
is that it can function as a relational database
instead of just a spreadsheet.
But it does that without changing the traditional look
and feel of a spreadsheet.
Even though this kind of works like a database,
you can just go to the bottom
of one of the columns and type in a formula.
So here I'm going to type in the SUM function,
the exact same language as Excel and Sheets,
the same syntax and the same shortcuts.
So I'm going to hold down Control and Shift,
hit the up key, it goes up to the top.
Okay, so we're in familiar territory here.
I'm going to delete that
and this is just starting out as more of a defined table.
So you can see the header labels are at the top.
You can move those down if you want.
You can define a new header row
but it's kinda handy to have them start out this way
because that makes this program more aware
of the type of data that's in each one of these columns.
So let's go over to D
and you see how these look different.
These are actually select boxes
where you can drop it down and change the value.
And all of these options are controlled at the top
of each column.
So if I left click on this arrow and drop it down,
you can edit the data type.
So we'll take a look at that
and this one is a data type called Select.
So you could do this in Sheets or Excel
but you'd have to do data valuation
and you could only have it as a dropdown
that you could select one item at a time
but this would have the option of a multiselect as well.
And all sorts of other different things
that we can get into in later videos.
There's lots of cool stuff to talk about.
So let's leave this as Select for now
and you have this nice control right here
instead of having to go into data validation
where you have the options
and you can even control their colors, right?
That's important.
Let's not forget about that.
But these are not set to strict.
So if I were to put a check mark in Strict,
I could not put a formula at the bottom of this column.
And you can only choose from these.
Okay, so unchecking it makes it default
to being able to use these.
But if it's not set as strict,
then you can also put other things in the column,
so that's a very important flexibility
that spreadsheet.com has.
I'm going to cancel out of that.
Let's look at another data type.
So these are just file uploads.
They're all images but if you click on the paperclip,
we have links here to other popular services
or you can just say My Device
and look for images there.
Some of these are some of the thumbnails
that I've been trying out.
Let's put that in there.
We'll say Open, upload one file.
So it'll let you put two files in.
Learn something new every day.
All right, we'll close this out.
So this entire data type is new in spreadsheet.com.
You could put an image in Sheets
but it's not that easy
and you can't just upload it
and you certainly can't have more than one.
As we go through these,
it's important to keep in mind
that we still have the core functionality of a sheet.
So for example, if you wanted to sort by name,
just left click on this arrow and you can sort.
You can do the other traditional things.
There's a filter, you can insert columns.
These are nothing revolutionary
but it's important to know that they're here
because it makes the look and feel backwards compatible
with a traditional spreadsheet.
All right, so here's one mind-blowing difference.
This data right now's in your traditional grid
but you can just left click on the little picker here,
the different views and you can show it in a Kanban view.
So let's look before I click on this.
It's going to say products by category.
Let's come back out of here.
Category's column D
and you see that this is a dropdown selection.
So your choices are going to be the dropdowns
because it's more limited.
There are only so many of them.
So this will make sense when you show products by category.
Each one of those dropdown categories now
is its own column and it has these nice-looking cards.
If this just cool looking and not very useful
or it useful?
I think it's useful.
Let's just left click on this modern couch
and say we want it in a new category.
Although a couch is not a lamp,
we're going to say we think it is.
And you just drag it over.
All right, so having the images here
and being able to visually organize it is very helpful.
For example, I'm seeing this is not a lamp,
so we're gonna put it back.
All right, if you just left click on one of these,
it will expand it and this again
is the same data that you were seeing in that grid
but it's showing it to you in a different way.
You could have a conversation with another user right here
about just this item.
So if I was working with someone else,
I could say hey, isn't this a whatever?
Emoji.
All right, that made no sense
but we're gonna get out of there.
I've no one else to talk to in here right now,
it's just me, so we will close this.
Let's say we see this side table.
We think it should be a lamp.
Let's look at this first.
This is 20-0004.
We're going to move it from side table to lamp.
Let's go back to the regular grid that we're used to.
Find 20-0004 and see, it was moved to lamp.
All right, so not only is it a different view
but it's a totally functional view
and you can use it in a completely different way.
Another completely new concept in here,
let's find a tab where this may make more sense.
Let's say that these three addresses
really all belong together.
Maybe these are just down the street
from this main warehouse.
Let's select these two.
And we will indent them
and you see what happened over to the left here
is that these became subsets
or children of this parent.
Okay, so those now stay together
and this relationship is understood
that PHX5 and PHX6 belong under this one.
So if you were to sort these,
let's say sorted by street address.
These relationships stay together
and you can tell visually that they belong together.
You also can collapse them and expand them, all right?
So you see the street address is sorted
but these were their own sorted subset.
If they weren't children of that parent,
they would be in a different order.
So let me know in the comments
if you find this interesting,
if you wanna see more videos on it
or if you have questions.
It's really the first time I've seen it
and I find it incredibly fascinating
and I'd like to show you more of what it could do.
Thanks for watching and I'll see you in the next video.