Human Resources
Discussion List
-
Change symbol based on dateIn Formulas and FunctionsGood morning Everyone, I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which…
-
Help with Update RequestIn Using SmartsheetI am asking leaders to fill out a form for promotion nominations with 3-5 contacts/emails for stakeholder feedback. My hope was to automate a request to each contact once the leader had submitted the form. Each stakeholder would get an u…
-
TimeStamp Formula ValueIn Using SmartsheetHi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match …
-
How to make a sheet that only shows the last x entries of another sheetIn Using SmartsheetHello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am …
-
Using Smartsheet to Track Employee Compliance AttestationsIn Using SmartsheetI'm wondering if anyone has created a managable way of tracking the status of employee policy attestations across 100+ employees and upwards of 20+ compliance documents. I've downloaded the Smartsheet Policy Governance Templates however t…Answered - Pending Review 28 views 2 comments 0 points Most recent by Richard Kendall Using Smartsheet
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
Automatically adding infoIn Formulas and FunctionsI am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has…Answered - Pending Review 15 views 2 comments 0 points Most recent by Janelle Formulas and Functions
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
-
How do I do a min/max output based upon a specific criteria?In Formulas and FunctionsSo I think I've come close to this in the area of indexing, matching, etc., but I can't quite get the formula to work the correct way. I have a sheet setup to where it calculates the average number of days that specific jobs have been open…
-
Avoiding #INVALID DATA TYPE when cells are blankIn Formulas and FunctionsHello, I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message. There are 2 formulae set up within the sheet: Leave Remaining (the dark grey row) is calculated as follo…
