Human Resources

 

Discussion List

  • Using Smartsheet to Track Employee Compliance Attestations
    In Using Smartsheet
    I'm wondering if anyone has created a managable way of tracking the status of employee policy attestations across 100+ employees and upwards of 20+ compliance documents. I've downloaded the Smartsheet Policy Governance Templates however t…
    Answered - Pending Review
    24 1
    Answered - Pending Review 24 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Vacation & Time-Off Management
    In Using Smartsheet
    Has anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?  
    2749 15
    2.7K views 15 comments Most recent by Genevieve P. Using Smartsheet
  • Automatically adding info
    In Formulas and Functions
    I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Janelle Formulas and Functions
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1348 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • How do I do a min/max output based upon a specific criteria?
    In Formulas and Functions
    So I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of days that specific jobs have been open…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Marc Bills Formulas and Functions
  • Avoiding #INVALID DATA TYPE when cells are blank
    In Formulas and Functions
    Hello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the dark grey row) is calculated as follo…
    1440 6
    1.4K views 6 comments Most recent by Amy Shank Formulas and Functions
  • SumIf
    In Formulas and Functions
    I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying to print out their hours added together…
    Accepted
    24 3
    Accepted Answer 24 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • How do I calculate the number of years between a date and today?
    In Using Smartsheet
    I have a Smartsheet tracking our team member work anniversary dates so that supervisors get alerted prior to a work anniversary occurring and then can congratulate that team member on the day of. I currently have: A hire date column: Bran…
    Answered - Pending Review
    96 3
    Answered - Pending Review 96 views 3 comments Most recent by Ahmed Elmonoufy Using Smartsheet
  • Calculating cumulative values and reducing the total sum each day
    In Formulas and Functions
    Hi, I have a Safety Violation Sheet that uses Form Entry to record violations and assign a measured Probation Period in days. If there are multiple entries for an individual, the probation days should accumulate, at the same time the value…
    Answered - Pending Review
    116 6
    Answered - Pending Review 116 views 6 comments Most recent by Shawn Leahy Formulas and Functions
  • Possible to send a identify verification SMS via DocuSign with Smartsheet?
    In Using Smartsheet
    I would like to send an attachment via Smartsheet/DocuSign API and set up already the template. But I can't figure out how to set up the mobile number in Smartsheet that the recipient can receive the identity verification SMS. Does anybo…
    Accepted
    22 1
    Accepted Answer 22 views 1 comment Most recent by Genevieve P. Using Smartsheet