ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
CRM TEMPLATE
5
[Company or Team Name]
6
7
NameJobPhoneEmailEstimated SaleLast ContactNext ActionNext ContactLead StatusOwnerNotes
8
Jameson, BillConstruction111-111-1111 $ 10,000 10/5/202029/5/2020❄ ColdSam
9
Anderson, JaneSales $ 10,000 25/5/20205/6/2020♨ WarmTim
10
Smithers, Joe $ 4,500 27/5/202015/6/2020🔥 HotSallyLoves chocolate
11
---
12
---
13
---
14
---
15
---
16
---
17
---
18
---
19
---
20
---
21
---
22
---
23
24
Insert new rows above the gray line
[42]
25
26
Feel free to hide these rows if you don't care to adjust the conditional formatting in the CRM table
27
Days Since Last Contact (<=)Days Until Next Action (>=)
28
210
29
55
30
> 5< 5
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