Human Resources
Discussion List
-
SumIfIn Formulas and FunctionsI 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…
-
How do I calculate the number of years between a date and today?In Using SmartsheetI 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 views 3 comments 0 points Most recent by Ahmed Elmonoufy Using Smartsheet
-
Calculating cumulative values and reducing the total sum each dayIn Formulas and FunctionsHi, 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 views 6 comments 0 points Most recent by Shawn Leahy Formulas and Functions
-
Possible to send a identify verification SMS via DocuSign with Smartsheet?In Using SmartsheetI 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…
-
How to Setup A Date Formula Based on a Conditional StatementIn Formulas and FunctionsI 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…
-
Return status of cell (blank vs. full) at today's date.In Formulas and FunctionsHello! 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…
-
Auto send a completed form to an email addressIn Using SmartsheetHi, 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…
-
Managing Move/Copy Row AutomationIn Formulas and FunctionsHello 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 …
-
Row/Column Level AccessIn Using SmartsheetI 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 views 13 comments 0 points Most recent by Andrée Starå Using Smartsheet
-
Tracking Employee Training and CertificationsIn Using SmartsheetHello! 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!
