670 likes | 840 Views
SharePoint in the World of Human Resources COM709. Who Am I?. Sandra Mahan PHR – Professional in Human Resources Idaho. Real-World Examples. Business Continuity Plan Job Description Template Performance Review Company Credit Card Wellness Program. Business Continuity Plan.
E N D
Who Am I? • Sandra Mahan • PHR – Professional in Human Resources • Idaho
Real-World Examples • Business Continuity Plan • Job Description Template • Performance Review • Company Credit Card • Wellness Program
User Request • Word Document with 20+ pages • Ongoing revisions • Multiple Users • Reporting
Reporting Calculated fields with nested IF statement =IF(AND(AND([Customers Complete]=TRUE), AND([Communication Complete]=TRUE), AND([Plan Details Complete]=TRUE), AND([Org Chart Complete]=TRUE), AND([Vendors Complete]=TRUE), AND([Dept Roster Complete]=TRUE), AND([Staffing Complete]=TRUE), AND(NOT(ISBLANK([Annual Call Tree Exercise]))), AND(NOT(ISBLANK([Annual Call Tree Resolved]))), AND(NOT(ISBLANK([Qtrly Updates]))), AND(NOT(ISBLANK([Training])))),"Complete","----")
Conditional Formatting Quarter calculation: =TODAY()-92 ($AO$1) Annual calculation: =TODAY()-365 ($AN$1)
Outcome • Calculated field • SharePoint view that can be filtered • Conditional formatting in Excel
User Request • Template with instructions • Standardized format
Outcome • Drop-down Lists • Print view • Alternative text
User Request • Multiple performance objectives • Supervisor and Employee can complete different sections • Sign the form • Protect form from others
Outcome • Repeating tables • Validate user (opened by) • Set a field’s value • Impersonation workflow • Manager Dashboard
User Request • Instructions • Application • Quiz • Approval Process
Quiz Calculation my:Quiz/my:Q1 + my:Quiz/my:Q2 + my:Quiz/my:Q3 + my:Quiz/my:Q4 + my:Quiz/my:Q5 + my:Quiz/my:Q6 + my:Quiz/my:Q7 + my:Quiz/my:Q8 + my:Quiz/my:Q9 + my:Quiz/my:Q10 + my:Quiz/my:Q11 + my:Quiz/my:Q12 + my:Quiz/my:Q13 + my:Quiz/my:Q14 + my:Quiz/my:Q15 + my:Quiz/my:Q16 + my:Quiz/my:Q17 + my:Quiz/my:Q18 + my:Quiz/my:Q19 + my:Quiz/my:Q20 != 200
Outcome • Show / Hide Sections • Calculate Quiz Score
User Request • Create a Wellness Program • Include click to validate programs as well as seasonal wellness programs • Can only see individual form • Can’t see future program weeks