Tables
Employees
A table of company employees
This would be your starting point- a list of known employees with basic info. It’s filled with random data for the most part. The ‘Eligible’ field could be a formula evaluating a couple columns to determine if an employee is even eligible for the mentor program. 🤷♀️
This helps to weed out the number of candidates to review later on if we can automate who is ineligible right off the bat based on known criteria about the employee. 🏏
Clear Sample Data
12
Add Employee
👩✈️ Employees
Employee Nbr
Full Name
Hire Date
Longevity
Location
Military
Current Eligibility
Email
📝Applications
📝Latest Application
📝 Application Status
Notes
1
Pilot 1
7/25/2014
4036 days
Location 4
Yes
Yes
Pilot 1@example.com
23
25
44
44
Ineligible
Open
2
Pilot 2
9/15/2007
6541 days
Location 2
Yes
Yes
Pilot 2@example.com
24
35
43
43
Ineligible
Open
3
Pilot 3
7/20/2010
5502 days
Location 3
Yes
Yes
Pilot 3@example.com
26
26
Denied
Open
4
Pilot 4
9/22/2016
3246 days
Location 9
Yes
Yes
Pilot 4@example.com
31
37
40
40
Ineligible
Open
5
Pilot 5
9/16/2005
7270 days
Location 9
No
No
Pilot 5@example.com
27
28
41
41
Open
6
Pilot 6
5/29/2009
5919 days
Location 1
Yes
Yes
Pilot 6@example.com
42
42
Ineligible
Open
7
Pilot 7
10/29/2019
2114 days
Location 10
No
No
Pilot 7@example.com
Open
8
Pilot 8
4/24/2010
5589 days
Location 3
Yes
Yes
Pilot 8@example.com
29
29
Under Review
Open
9
Pilot 9
4/5/2021
1590 days
Location 2
No
No
Pilot 9@example.com
32
39
39
Ineligible
Open
10
Pilot 10
7/8/2024
400 days
Location 3
No
No
Pilot 10@example.com
34
38
38
Ineligible
Open
11
Pilot 11
12/25/2014
3883 days
Location 11
Yes
Yes
Pilot 11@example.com
30
36
36
Open
12
Pilot 12
10/17/2011
5048 days
Location 10
No
No
Pilot 12@example.com
Open
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.