Human Resources
Discussion List
-
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…Answered - Pending Review 1 view 2 comments 0 points Most recent by Clayton Richards Formulas and Functions
-
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 31 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!
-
Index, Match, Max, CollectIn Formulas and FunctionsI 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…
-
Finding Duplicate User IDs in one columnIn Formulas and FunctionsHello 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: =…
-
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…
-
How to calculate elapsed time between status changes ?In Formulas and FunctionsHello, 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 views 2 comments 0 points Most recent by Nicolas Houle Formulas and Functions
-
Line chart with multiple date-numbers tracesIn Using SmartsheetHello 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 1.5K views 24 comments 1 point Most recent by Angel Trevino Using Smartsheet
