Test Timeline
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Today's DateTasks TodayTimeline Start
Timeline Ruler (3 months - divisions by week - white marker = today)
Timeline End Tasks TomorrowDate RangeTask NotesStart of Calendar Week (Sunday)Sunday, November 11, 2018
2
Tuesday, December 11, 20182Nov.-11Feb.-9290Date Values (conditional)Color tagsTomorrow
Data Argument: { Array aka "list" of Values }
Options Argument: { Key-Value pairs for option parameters }
3
TASK DESCRIPTIONBRANDTask StartTask EndStatusHours LoggedFile LocationTask TodayTask Tomorrowbuffer valueDays AssignedgrayDecember, 3Sunday, November 11, 20182018-12-12
{ int(B10)-int($B$2),int(B10)-today(), 1, int(B10)-int(C10) }
{"charttype","bar";"color1","white";"color2",if(F10="Complete","grey",if(today()>C10,"orange",E10));"empty","zero"; "max",int($C$2)-int($B$2)}
4
AdVERDec.-1Jan.-28Ongoing11202,981green
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
5
Corporate ContractCIRFeb.-02Feb.-9Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
6
General PresentationCIRFeb.-02Feb.-10Active0000teal
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
7
Open House MediaCIRDec.-20Dec.-29Complete0000Light Gray
{ int(B4)-int($B$2), int(C4)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F4="Complete","lightgrey",if(today()>C3,"orange",E4));"empty","zero"; "max",int($C$2)-int($B$2)}
8
Free Vendor Ad for Bridal Exhibition VERDec.-27Dec.-28Approval0000magenta
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
9
Poster for R TeamCIRJan.-3Jan.-5Complete0000Light Gray
{ int(B5)-int($B$2), int(C5)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F5="Complete","lightgrey",if(today()>C3,"orange",E5));"empty","zero"; "max",int($C$2)-int($B$2)}
10
Graphic StandardsHEADDec.-29Jan.-5Pending0000orange
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
11
Business CardsHEADDec.-29Jan.-3Upcoming0000purple
{ int(B6)-int($B$2), int(C6)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F6="Complete","lightgrey",if(today()>C3,"orange",E6));"empty","zero"; "max",int($C$2)-int($B$2)}
12
Guest Feedback Cards SPASPAJan.-2Jan.-5Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
13
Kids Movie PassesVERJan.-9Jan.-10Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
14
Kids Movie Poster VERJan.-9Jan.-10Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
15
Children's Party PhotosHEADJan.-5Jan.-19Pending0000orange
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
16
SPA Staff PhotosSPAJan.-2Mar.-10Pending0000orange
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
17
Winter Menu PhotosSUMJan.-8Jan.-12Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
18
Nicholas - Marketing PhotosCIRFeb.-1Feb.-16Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
19
Porsche and AudiCIRFeb.-28Jul.-31Upcoming0000purple
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
20
Event PhotosCIROngoing113090green
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
21
22
23
24
Ballot Box CardsVERDec.-28Dec.-28Critical0000red
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
25
New Years BEO MenuVERDec.-28Dec.-28Complete0000Light Gray
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
26
Wedding BrouchureVERDec.-18Dec.-22Complete0000Light Gray
{ int(B3)-int($B$2), int(C3)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F3="Complete","lightgrey",if(today()>C3,"orange",E3));"empty","zero"; "max",int($C$2)-int($B$2)}
27
Bus ShelterVERDec.-11Dec.-22Complete0000Light Gray
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
28
29
30
Test Expired Item- beyond timelineHEADJul.-4Nov.-15ActiveAdjust date range to see past timelines0000teal
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
31
Test Future ItemHEADFeb.-22May-18Active0000teal
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
32
Test Active ItemHEADDec.-25Dec.-27ActiveActive flag and past date test0000teal
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
33
Test Active ItemHEADDec.-25Jan.-5Pending0000orange
{ int(B7)-int($B$2), int(C7)-int(B$B2) }
{"charttype","bar";"color1","white";"color2",if(F7="Complete","lightgrey",if(today()>C3,"orange",E7));"empty","zero"; "max",int($C$2)-int($B$2)}
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
Loading...
Main menu