target_sheet

	A	B	C	E
1	Team	Name	Website
2	Team Blue	Ken	http://example.com/u/ken
3	Team Blue	Ron	http://example.com/u/ron
4	Team Blue	Lisa	http://example.com/u/Lisa
5	Team Red	Jeff	http://example.com/u/jeff
6	Team Red	Jack	http://example.com/u/jack
7	Team Red	Jill	http://example.com/u/jill
8	Team Black	Pauline	http://example.com/u/pauline
9	Team Black	Andy	http://example.com/u/andy
10	Team Black	Miki	http://example.com/u/miki
11
12
13				Please note I connected this spreadsheet to a dashboard. In the morning, column C in the dashboard will say "#NAME?". But when I open source_sheet, it takes a few seconds later and the "#NAME?" will disappear.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100