Human Resources

 

Discussion List

  • 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
    21 3
    Accepted Answer 21 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
    81 3
    Answered - Pending Review 81 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
    87 6
    Answered - Pending Review 87 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
  • How to Setup A Date Formula Based on a Conditional Statement
    In Formulas and Functions
    I have a date column for noting when someone's contracted employment will end. I'd like to create a formula to reference that date, subtract 180 days from it if their appointment term is "Limited" else the reminder date will be 9…
    Accepted
    3 2
    Accepted Answer 3 views 2 comments Most recent by Genevieve P. Formulas and Functions
  • 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
    Accepted Answer 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
    2233 16
    Accepted Answer 2.2K 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
    44 13
    Answered - Pending Review 44 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
    825 4
    Accepted Answer 825 views 4 comments Most recent by Andrée Starå Using Smartsheet