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…
    Accepted
    13 2
    Answered ✓ 13 views 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
    3540 16
    Answered ✓ 3.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
    14 7
    Answered ✓ 14 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
    122 13
    Answered - Pending Review 122 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
    1402 4
    Answered ✓ 1.4K 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
    92 7
    Answered ✓ 92 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
    37 1
    Answered ✓ 37 views 1 comment Most recent by Mark Cronk Formulas and Functions
  • 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
    131 2
    Answered - Pending Review 131 views 2 comments Most recent by Nicolas Houle Formulas and Functions
  • Functional Requirements in Smartsheet
    In Using Smartsheet
    Hello, Our project team recently transitioned to Smartsheet.  I am currently deciding how we will develop Functional Requirements (e.g. Excel, Smartsheet, Word, One Note, etc.) and eventually test cases.  Is there anyone using Smartsheet …
    1258 9
    1.3K views 9 comments Most recent by Genevieve P. Using Smartsheet
  • Automatically Change "Modified by" email item into a Name
    In Using Smartsheet
    Hello! My team is creating a form to collect, track, and act on paid-time-off requests and part of the system we're creating is making a form for folks to submit their requests through. We need to share parts of the content of this sheet…
    273 8
    273 views 8 comments Most recent by Krista Meston Using Smartsheet