Human Resources

Discussion List

  • Counting and Averaging with Exclusions
    In Formulas and Functions
    Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the …
    Accepted
    72 2
    Accepted Answer 72 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Calculating costs for a task over more than one month
    In Formulas and Functions
    I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, …
    Answered - Pending Review
    163 2
    Answered - Pending Review 163 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • How do I retrieve the Login History for a deleted user
    In Using Smartsheet
    I used to see the login history of the users in my organization. Unfortunately once I deleted a user I cannot see their login history anymore. How should I go back and retrieve the history of actual and former smartsheet users of my organi…
    Accepted
    65 2
    Accepted Answer 65 views 2 comments Most recent by Jean-Robert Adrien Using Smartsheet
  • Resource Management
    In Using Smartsheet
    If multiple resources are assigned to a Task, and the % Allocated is different for each resource, I assume that the only way that this can be correctly recorded in Smartsheet, is to duplicate the Task a number of times so that each Resourc…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Nigel Michell Using Smartsheet
  • Project stage and date in the Future
    In Formulas and Functions
    Hello Smartsheet super formula humans! I need some assistance! We are trying to create a formula where a checkbox is checked if the project meets the below criteria. Recurring On hold Pending approval + In Progress with a Go-Live date of a…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Krista Coffman Formulas and Functions
  • Return to Work Templates
    In Staying on the Same Sheet
    Has Smartsheet created or does anyone have any locally successful templates for helping to plan out Return to Work from a manning perspective? Specifically, our government office is working to have a max capacity (20-30%) of total workfor…
    Answered - Pending Review
    104 2
    Answered - Pending Review 104 views 2 comments Most recent by Andrée Starå Staying on the Same Sheet
  • Update Request Results showing data that was deleted from Update Req. Form
    In Formulas and Functions
    I am sending an Update Request (UR) form to employees to have them tell me how many hours they worked each day. The smartsheet is prefilled with 8 hours each day. So when the UR form get to the employee, they just make adjustments as neede…
    Answered - Pending Review
    23 3
    Answered - Pending Review 23 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Not so pretty IF-function (works) but needs makeover
    In Formulas and Functions
    Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes. In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which wor…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Sort by Parent Values Without Changing Order of Children Rows
    In Using Smartsheet
    I have multiple tasks each with multiple sub-tasks. The tasks and sub-tasks are not in alpha order, for example: Whether I leave the rows expanded or collapsed, when I sort the rows by task, it sorts the task and the sub-tasks, like so…
    617 7
    617 views 7 comments Most recent by Hillary Valor Using Smartsheet
  • Send a notification to an email address submitted in form.
    In Using Smartsheet
    Hello,  I am currently using SmartSheets for our staffing agencies to submit potential candidates to open requisitions. On our side of smartsheet, we have a drop down with the "status" of the candidate (Pending, submitted to hir…
    1964 10
    2K views 10 comments Most recent by chris Perry Using Smartsheet