ABCDEFG
1
View By:
2
Condition 1 Count (all-time)
3
Problem:"All-time" counts currently only go back the last two years with the formula in place; need to develop a reasonable formula that totals counts for all years for all-time, dynamically without requiring manual modifications to the formula year after year.U = Unfamiliar
F = Familiar
P = Proficient
E = Expert		Red
Yellow
Blue
4
Ideas:Total0%0%0%
5
Custom formula w/ script?Light0%0%0%0%
6
YTD filter range somehow?Medium0%0%0%0%
7
Google sheets can't do 3D references like Excel
Dark0%0%0%0%
8
9
10
11
12
13
14
15
16
17
18
19