1
00:00:00,080 --> 00:00:03,554
A shared order sheet needs two kinds of cells.

2
00:00:03,554 --> 00:00:07,801
Teammates should edit quantity and unit price, but a mistaken paste

3
00:00:07,801 --> 00:00:11,662
over a line-total formula can silently break the totals.

4
00:00:11,662 --> 00:00:16,680
This fictional exercise leaves B2 through C4 editable and restricts D2 through D4.

5
00:00:16,680 --> 00:00:20,927
Before changing permissions, we will build the formulas and check three

6
00:00:20,927 --> 00:00:23,629
expected amounts: thirty six, thirty, and fifteen.

7
00:00:24,229 --> 00:00:27,749
The download contains three invented items: Binder, Pens, and Clips.

8
00:00:27,749 --> 00:00:30,917
Each row has a quantity and a unit price.

9
00:00:30,917 --> 00:00:34,789
Paste the CSV into a native Google Sheet, then add a

10
00:00:34,789 --> 00:00:36,901
Line total header in column D.

11
00:00:36,901 --> 00:00:39,365
Do not share this practice file publicly.

12
00:00:39,365 --> 00:00:43,237
The item names are only test data; the protection rule is

13
00:00:43,237 --> 00:00:46,405
about cell coordinates, not the words in the table.

14
00:00:47,005 --> 00:00:51,346
In D2, multiply quantity in B2 by unit price in C2.

15
00:00:51,346 --> 00:00:55,688
Enter the expression shown on screen, then fill it down to

16
00:00:55,688 --> 00:00:58,056
D4 so the row references advance.

17
00:00:58,056 --> 00:01:02,398
If your locale uses different currency display, the arithmetic is unchanged.

18
00:01:02,398 --> 00:01:05,950
Compare all three results before protecting anything, because a

19
00:01:05,950 --> 00:01:09,107
protection rule should not hide a formula error.

20
00:01:09,707 --> 00:01:11,562
Select D2 through D4 only.

21
00:01:11,562 --> 00:01:17,128
Open Data, then Protect sheets and ranges, and add a Range rule for D2:D4.

22
00:01:17,128 --> 00:01:21,209
Google says this command may be missing while editing an Office

23
00:01:21,209 --> 00:01:24,919
file, so convert to a native Google Sheet if needed.

24
00:01:24,919 --> 00:01:28,629
Read the range text carefully before applying permissions; an accidental

25
00:01:28,629 --> 00:01:31,968
full-sheet rule would also lock the input cells.

26
00:01:32,568 --> 00:01:36,117
In the permissions dialog, distinguish a warning from a restriction.

27
00:01:36,117 --> 00:01:40,020
Show a warning when editing this range asks an editor to

28
00:01:40,020 --> 00:01:42,505
confirm but does not stop the edit.

29
00:01:42,505 --> 00:01:46,408
For this exercise, choose Restrict who can edit this range and

30
00:01:46,408 --> 00:01:48,892
select Only you for the formula cells.

31
00:01:48,892 --> 00:01:52,796
The owner can still edit them; the rule is meant to

32
00:01:52,796 --> 00:01:54,925
prevent other editors from accidental changes.

33
00:01:55,525 --> 00:01:59,596
Check the values in D2 through D4: thirty six for Binder,

34
00:01:59,596 --> 00:02:02,187
thirty for Pens, and fifteen for Clips.

35
00:02:02,187 --> 00:02:06,628
Then inspect the protection panel and confirm its range says D2:D4

36
00:02:06,628 --> 00:02:08,108
with the intended restriction.

37
00:02:08,108 --> 00:02:11,809
B2 through C4 should not be in that protected range.

38
00:02:11,809 --> 00:02:15,879
If you have a trusted test editor, verify that person can

39
00:02:15,879 --> 00:02:18,840
change an input but cannot overwrite a formula.

40
00:02:19,440 --> 00:02:23,044
Protected ranges prevent certain edits, but Google explicitly says they

41
00:02:23,044 --> 00:02:24,846
are not a security measure.

42
00:02:24,846 --> 00:02:29,891
People with access may print, copy, or export a sheet, depending on their permissions.

43
00:02:29,891 --> 00:02:33,856
Share the file only with people you trust and use file

44
00:02:33,856 --> 00:02:35,297
sharing controls for access.

45
00:02:35,297 --> 00:02:39,261
When you add new rows later, extend both the formulas and

46
00:02:39,261 --> 00:02:42,145
the protected range, then repeat the answer check.