ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ManagerTeamUserExceptions
2
SidraABCZaraAcct1|Vincy,Acct2|Renu
3
AliABCVincy
Updated from SFReport
4
ShariqDEFZara
Manual entry columns or default should be `Unassigned`
5
RidaDEFZaraAcct3|Zuha,Acct4|Vincy
6
RaviGHIVincy
7
YilmayGHIVincy
8
ManoJKLRenu
9
CindyJKLZuha
10
11
* Self-referencing table that will be loaded to a Mappings worksheet, that will pull new Manager & their Team names from SFReport query and add it below
12
* Initially when any new Manager & Team names are appended to the table, the User name should be entered as `Unassigned`
13
* User column is a manual-entry column which will assign User to Manager.
14
* Exceptions column is a manual entry column. Format : <Account|User>,<Account|User>,<Account|User> etc
15
* Exceptions column is where for any Acct exception mentioned, the combination of Manager-User should be looked up and replaced with new User for that Acct.
16
* This table may increase or decrease depending on which Manager, Team or User is no longer within the organization, thereby affecting the sort order in Exceptions column.
17
so the Exceptions column values should refer correctly to that Manager-User combination whenever any rows get deleted or added.
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