Human Resources

 

Discussion List

  • Return status of cell (blank vs. full) at today's date.
    In Formulas and Functions
    Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS da…
    Answered - Pending Review
    1 2
    Answered - Pending Review 1 view 2 comments Most recent by Clayton Richards Formulas and Functions
  • Auto send a completed form to an email address
    In Using Smartsheet
    Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields…
    Accepted
    1515 16
    Accepted Answer 1.5K views 16 comments Most recent by Joe Araujo Using Smartsheet
  • Managing Move/Copy Row Automation
    In Formulas and Functions
    Hello I have an employee database stored in Smartsheet. I've connected an onboarding form to a separate sheet which gathers sensitive data. I want to move that information over to the database, but not have some of the sensitive data come …
    Accepted
    11 7
    Accepted Answer 11 views 7 comments Most recent by Andrée Starå Formulas and Functions
  • Row/Column Level Access
    In Using Smartsheet
    I have sheet on which people from multiple departments will have access to. A couple of my requirements: 1) I'd like certain departments to be able to see only the data in specific columns only relevant to them. Is this possible? 2) There…
    Answered - Pending Review
    31 13
    Answered - Pending Review 31 views 13 comments Most recent by Andrée Starå Using Smartsheet
  • Tracking Employee Training and Certifications
    In Using Smartsheet
    Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
    Accepted
    554 4
    Accepted Answer 554 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Index, Match, Max, Collect
    In Formulas and Functions
    I am trying to use the following formula to identify the name of the last Manager in Training (MIT) to graduate their training program with a certain Mentor, but wherever there are instances of MITs having the same graduation date, the for…
    Accepted
    41 7
    Accepted Answer 41 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • Finding Duplicate User IDs in one column
    In Formulas and Functions
    Hello Smartsheet community, I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids. We've tried this formula: =…
    Accepted
    21 1
    Accepted Answer 21 views 1 comment Most recent by Mark Cronk 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
    31 2
    Answered - Pending Review 31 views 2 comments Most recent by Mark S Krebs Using Smartsheet
  • How to calculate elapsed time between status changes ?
    In Formulas and Functions
    Hello, Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green. Ideally, I would like to be able to calculate a mean per terr…
    Answered - Pending Review
    21 2
    Answered - Pending Review 21 views 2 comments Most recent by Nicolas Houle Formulas and Functions
  • Line chart with multiple date-numbers traces
    In Using Smartsheet
    Hello everyone!   I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
    Answered - Pending Review
    1482 24
    Answered - Pending Review 1.5K views 24 comments Most recent by Angel Trevino Using Smartsheet