People

<aside> <img src="/icons/database_gray.svg" alt="/icons/database_gray.svg" width="40px" />

Source DB

People

</aside>

Property Type Description
Name Title Persons name
Company Select Persons enterprise
Position Select Persons position/role
Email Email Persons email address
Member Person Notion member
Is Active Checkbox Stakeholder Active / Employee
Projects Relation ‣ DB
Tasks Relation ‣ DB
Time Tracking Relation DB
Track Time Button Add time-tracking
Q1-YTD Days Roll-up (Time tracking) Days time-tracked for Q1 Current year
Q2-YTD Days Roll-up (Time tracking) Days time-tracked for Q2 Current year
Q3-YTD Days Roll-up (Time tracking) Days time-tracked for Q3 Current year
Q4-YTD Days Roll-up (Time tracking) Days time-tracked for Q4 Current year
Q1-YTD Workload Formula Q1 Current year days (%) - Max 60
Q2-YTD Workload Formula Q2 Current year days (%) - Max 60
Q3-YTD Workload Formula Q3 Current year days (%) - Max 60
Q4-YTD Workload Formula Q4 Current year days (%) - Max 60
Empty Name Formula (flag) Missing Name
Empty Company Formula (flag) Missing Company
Empty Position Formula (flag) Missing Position
Data Health Formula (flag) Any Flag detected
Name Alert Formula (flag) Empty Name text display
Company Alert Formula (flag) Empty Company text display
Position Alert Formula (flag) Empty Position text display

Time tracking

<aside> <img src="/icons/database_gray.svg" alt="/icons/database_gray.svg" width="40px" />

Source DB

Time Tracking

</aside>

Property Type Description
Name Title TT name
Days Number TT days
Date Date TT Date
Projects Relation ‣ DB
People Relation DB
Project ID Roll-up (Project) Project Identifier
Quarters Formula Date Quarters (YYYY-QQ)
Q1-YTD Days Formula Days time-tracked for Q1 Current year
Q2-YTD Days Formula Days time-tracked for Q2 Current year
Q3-YTD Days Formula Days time-tracked for Q3 Current year
Q4-YTD Days Formula Days time-tracked for Q4 Current year
Empty Name Formula (flag) Missing Name
Empty Date Formula (flag) Missing Date
Empty People Formula (flag) Missing People
Empty Project Formula (flag) Missing Project
Wrong Days Formula (flag) Missing or ne
Data Health Formula (flag) Any Flag detected
Name Alert Formula (flag) Empty Name text display
Date Alert Formula (flag) Empty Date text display
Person Alert Formula (flag) Empty Person text display
Project Alert Formula (flag) Empty Project text display
Days Alert Formula (flag) Wrong Days text display