1
00:00:00,210 --> 00:00:03,390
The comment functionality
in sheets is robust.

2
00:00:03,390 --> 00:00:07,403
The way we make a comment is we click on
the cell where we wanna make a comment,

3
00:00:07,403 --> 00:00:09,741
and we go up to Insert,
and select Comment.

4
00:00:09,741 --> 00:00:12,080
Note there's also a keyboard shortcut for
this.

5
00:00:13,490 --> 00:00:15,880
And this box pops up.

6
00:00:15,880 --> 00:00:20,920
I can say,
this is an example comment to myself.

7
00:00:23,410 --> 00:00:25,460
And there we go.

8
00:00:25,460 --> 00:00:29,720
Now I click somewhere else and
the comment disappears.

9
00:00:29,720 --> 00:00:34,530
And I go over here, now if I mouse
over the cell with the comment in it,

10
00:00:34,530 --> 00:00:36,160
it will pop up again.

11
00:00:36,160 --> 00:00:40,480
You can see that there are comments in
cells because of this yellow-ish orange

12
00:00:40,480 --> 00:00:42,610
triangle here at the top of the cell.

13
00:00:44,010 --> 00:00:49,970
So I scroll over the cell with the comment
in it, and I can reply to this comment.

14
00:00:51,080 --> 00:00:54,110
I can also tag colleagues and

15
00:00:54,110 --> 00:00:56,570
they'll get notified via email
that they've been tagged.

16
00:00:56,570 --> 00:00:59,945
So I could say @Rich.

17
00:01:01,950 --> 00:01:03,720
And there, his email pops up.

18
00:01:04,830 --> 00:01:08,832
And this is just a test, ignore.

19
00:01:11,011 --> 00:01:12,790
At your own peril [LAUGH].

20
00:01:14,690 --> 00:01:16,930
And there we go.

21
00:01:16,930 --> 00:01:20,540
Now, another thing is if I'd actually
been asking to do something in this

22
00:01:20,540 --> 00:01:23,190
spreadsheet, or answer a question,
I could do that there.

23
00:01:23,190 --> 00:01:26,794
And then when it's been resolved,
then the comment goes away.

24
00:01:26,794 --> 00:01:30,470
And you can see the history of all
the comments by just going back up here.

25
00:01:32,290 --> 00:01:35,560
Comments are great for collaboration
as they can speed up the exchange of

26
00:01:35,560 --> 00:01:38,830
information and
identify where action is required.

27
00:01:38,830 --> 00:01:41,610
We generally use notes
differently than comments.

28
00:01:41,610 --> 00:01:44,690
You can use notes to explain
what certain cells mean or

29
00:01:44,690 --> 00:01:49,150
why you set something up or also the
source of an assumption that's being made.

30
00:01:49,150 --> 00:01:53,260
Here we are in our retail budget
example back on the Input tab.

31
00:01:54,620 --> 00:02:03,730
I'm gonna scroll down to the Expense
Assumptions section and focus on row 26.

32
00:02:03,730 --> 00:02:07,245
The rent is going up every year, which we
know why it is, but to other people who

33
00:02:07,245 --> 00:02:10,629
are using the spreadsheet, they might
not know and that might look weird.

34
00:02:11,630 --> 00:02:17,364
So, I'm going to insert
a note to give context.

35
00:02:17,364 --> 00:02:22,718
Lease agreement requires 10%

36
00:02:22,718 --> 00:02:26,927
increase in year 1 rent.

37
00:02:29,734 --> 00:02:32,825
So now, someone who might
wonder what's going on there

38
00:02:32,825 --> 00:02:37,115
can scroll over the cell and see the
comment that explains why it's going up.

39
00:02:39,529 --> 00:02:42,248
What about on the revenue side?

40
00:02:42,248 --> 00:02:43,590
$25 for the hats.

41
00:02:44,750 --> 00:02:47,050
What and how did we arrive at that price?

42
00:02:47,050 --> 00:02:51,977
Well, it might be because we know it
costs us $10 to make the hats and

43
00:02:51,977 --> 00:02:54,579
we're gonna mark them up by $15.

44
00:02:54,579 --> 00:02:59,403
So instead of just putting $25, we've
actually entered in that information into

45
00:02:59,403 --> 00:03:03,590
the formula, but
it's still not immediately obvious.

46
00:03:03,590 --> 00:03:09,767
Another way to do this is we could
say okay, it's gonna be $10 + 15.

47
00:03:09,767 --> 00:03:14,329
And here because we're referencing
the cell, people can see, okay,

48
00:03:14,329 --> 00:03:19,860
well the cost is $10 and we're adding
$15 on the cost, which is fine.

49
00:03:19,860 --> 00:03:21,956
But just for the example's sake.

50
00:03:25,107 --> 00:03:28,946
We'll insert a note.

51
00:03:28,946 --> 00:03:34,880
$10 cost plus $15 markup.

52
00:03:34,880 --> 00:03:38,820
Now it's certainly best practice
when you're inserting notes to also

53
00:03:40,370 --> 00:03:43,450
say who put it, with initials.

54
00:03:43,450 --> 00:03:44,670
You could spell out your full name.

55
00:03:44,670 --> 00:03:47,040
Everyone around here calls me Watson,
so I'll just write Watson.

56
00:03:49,170 --> 00:03:52,212
Also note that you can adjust
the size of the comment box.

57
00:03:55,561 --> 00:03:59,420
The difference between comments and
notes is subtle, and in some cases,

58
00:03:59,420 --> 00:04:01,230
doesn't really matter.

59
00:04:01,230 --> 00:04:04,170
Indeed, lots of spreadsheet
software doesn't have the common

60
00:04:04,170 --> 00:04:07,640
functionality that Sheets has and
are really just notes.

61
00:04:07,640 --> 00:04:11,010
Keep that in mind because they can help
clarify things in your spreadsheets,

62
00:04:11,010 --> 00:04:14,320
particularly when you're
collaborating with other users.