ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
https://www.reddit.com/r/googlesheets/comments/hhv4bt/i_need_some_help_with_making_my_reports_dynamic/
2
Create DateUpdate DateNew DateIDNameProjectStage 1ReasonItemstartend
3
1/1/20191/1/20191/1/20191ABCXYLostPendingHi1/1/20193/10/2019
4
1/2/20191/2/20191/2/20192BCDXTWonPendingHey
5
1/3/20191/3/20191/3/20193CDEXYNewPendingHey
6
1/4/20191/4/20191/4/20194DEFXYLostPendingHi
7
3/10/20191/1/20193/10/20195DEFXTWonPendingHey
8
1/1/20193/10/20191/1/20196GHIXYNewPendingHi
9
3/10/20191/1/20191/1/20197JKLXYWonPendingHey
10
1/1/20193/10/20193/10/20198MNOXTNewPendingHey
11
12
ProjectNew DateStage 1
select by real date
13
XY1/1/2019Lost
14
XT1/2/2019Won
15
XY1/3/2019New
16
XY1/4/2019Lost
17
XT3/10/2019Won
18
XY1/1/2019New
19
XY1/1/2019Won
20
XT3/10/2019New
21
Show won and new projects only
22
ProjectNew DateStage 1
Sort by project, status
23
XT3/10/2019New
24
XT1/2/2019Won
25
XT3/10/2019Won
26
XY1/3/2019New
27
XY1/1/2019New
28
XY1/1/2019Won
29
30
31
32
ProjectNew DateStage 1
Sort by project name, active date
33
XT1/2/2019Won
34
XT3/10/2019Won
35
XT3/10/2019New
36
XY1/1/2019Lost
37
XY1/1/2019New
38
XY1/1/2019Won
39
XY1/3/2019New
40
XY1/4/2019Lost
41
42
43
NameStage 1total
Group by project, stage, show count of projects
44
XTNew1
Give headings new names
45
XTWon2
46
XYLost2
<- two lost items on project XY
47
XYNew2
48
XYWon1
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