Human Resources


Discussion List

  • Change symbol based on date
    In Formulas and Functions
    Good morning Everyone,  I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which…
    405 4
    405 views 4 comments Most recent by 22Wordsmith Formulas and Functions
  • Help with Update Request
    In Using Smartsheet
    I am asking leaders to fill out a form for promotion nominations with 3-5 contacts/emails for stakeholder feedback. My hope was to automate a request to each contact once the leader had submitted the form. Each stakeholder would get an u…
    Answered - Pending Review
    25 1
    Answered - Pending Review 25 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • TimeStamp Formula Value
    In Using Smartsheet
    Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match …
    3948 8
    Accepted Answer 3.9K views 8 comments Most recent by Andrée Starå Using Smartsheet
  • How to make a sheet that only shows the last x entries of another sheet
    In Using Smartsheet
    Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am …
    22 2
    Accepted Answer 22 views 2 comments Most recent by Kaleb Riley Using Smartsheet
  • 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
    28 2
    Answered - Pending Review 28 views 2 comments Most recent by Richard Kendall 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)?  
    3024 15
    3K 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
    15 2
    Answered - Pending Review 15 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…
    1409 5
    1.4K 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…
    20 2
    Accepted Answer 20 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…
    1547 6
    1.5K views 6 comments Most recent by Amy Shank Formulas and Functions