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…
-
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 122 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 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 131 views 2 comments 0 points Most recent by Nicolas Houle Formulas and Functions
-
Functional Requirements in SmartsheetIn Using SmartsheetHello, 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 …
-
Automatically Change "Modified by" email item into a NameIn Using SmartsheetHello! 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…