Human Resources

Discussion List

  • Calculate Date Employee turns 18
    In Formulas and Functions
    Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell.  I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payr…
    14 1
    14 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • find and replace text in an already created update request.
    In Using Smartsheet
    I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse.  I would like to remove …
    MB Profile Photo MB
    54 9
    54 views 9 comments Most recent by Scott Willeke Using Smartsheet
  • Checklist Form to Upload docs to DropBox
    In Using Smartsheet
    I have a form to collect data from Property Managers for each of my tenants. Each column is a document with a yes/no that will be checked on the form if the Property Manager uploads the document. Also on the form is a URL to the Dropbox fo…
    103 1
    103 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Inventory
    In Using Smartsheet
    Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
    22 2
    22 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Help with PDF Fillable Files on smartsheet app
    In Using Smartsheet
    I have salesman that use pdf fillable forms for company use. I created a sheet that has all the forms in it as attachments. When using the desktop version they click on the attachment and it brings up the file and they file in the informat…
    313 3
    313 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Conditional Formatting with multi select dropdown list
    In Using Smartsheet
    When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,. What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condit…
    73 1
    73 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Formula to calculate the amount of "done" rows for different years.
    In Formulas and Functions
    We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter…
    23 4
    23 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Scheduling by Skillset
    In Using Smartsheet
    Hello!   I am wondering if you can set scheduling on Smartsheet, and if you can, a program on Smartsheet for scheduling based on employee skill sets on Smartsheet.  If there is, how would I go about doing that, and what ways can we incor…
    32 5
    32 views 5 comments Most recent by MFuller Using Smartsheet
  • Free Collaborator / Unlicensed User
    In Using Smartsheet
    Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row.  secondly: if Unlicensed User delete row or…
    163 3
    163 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Filtering/Slicing in Dashbaords
    In Using Smartsheet
    Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard v…
    530 1
    530 views 1 comment Most recent by Andrée Starå Using Smartsheet