Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Human Resources
Discussion List
-
Accepted Answer Justin Runner 43 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…Formulas and Functions437Justin Runner -
First post 10/29/18,Last post 01/17/20I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project L…Formulas and Functions15726BryanHeft -
Answered Zachary Mitchell 21 views 2 comments 0 points Most recent by Mike L. Formulas and FunctionsFirst post 01/02/20,Last post 01/02/20My organization (a small physicians office) is creating a new onboarding check list via smartsheet. We want to update the staff on certain tasks they need to complete for new staff members going through the process. I've considered a few o…Formulas and Functions212Zachary Mitchell
-
First post 08/09/17,Last post 12/06/19I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…Archived 2017 Posts336Ben W
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions402KDub618
-
First post 12/05/19,Last post 12/05/19Hi I am planning to build a full-scale Human-Resource Management app in Smartsheet which will be used by approx 300 employees. I am fully aware of its functionality, storage-limits, workflows, etc., and I'm okay with all that. My only …Using Smartsheet275[email protected]
-
First post 10/15/19,Last post 11/26/19I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more contex…Using Smartsheet8046@CollabMeganPMP -
First post 11/21/19,Last post 11/25/19Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be tr…Formulas and Functions371cyndi_walker108886 -
First post 11/19/19,Last post 11/25/19May I know if there will be any alert when a sheet is reaching it's 5000th row? My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity? Thanks.Using Smartsheet193Vivien Chong
-
First post 11/22/19,Last post 11/22/19Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered in sheet #1. Is this possible?Using Smartsheet343Kayla Torontow -
First post 11/19/19,Last post 11/20/19Hi I would like to understand about this limitation in vlookup: * Each sheet can include no more than 100 distinct cross-sheet references. * There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet …Formulas and Functions403Vivien Chong
-
First post 11/08/19,Last post 11/17/19Hello, My story seems to be familiar to others, but no past post seems to have a good solution. I've been searching the community forums here for a request time off tracker template (found a couple none actually worked), ended up creating…Formulas and Functions221Tyler12345
-
First post 11/14/19,Last post 11/15/19Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…Premium Apps and Integrations221C_Carroll
-
First post 11/11/19,Last post 11/12/19I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…Formulas and Functions211Brad Huff
-
First post 11/05/19,Last post 11/07/19Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that…Formulas and Functions2683BKathy
-
First post 11/06/19,Last post 11/06/19Hi - I'm trying to add 6 months to the day to a date referenced in another field. It is basically a date of execution and plus 6 months a review date. How is this possible? Adding the number of days gets me close, but not exact. Thanks!Formulas and Functions261allison110246
-
First post 11/04/19,Last post 11/06/19Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: (Image) …Formulas and Functions173grant53396
-
First post 05/23/19,Last post 10/31/19I am working on a an extensive approval workflow with numerous steps and approvers. I am running into a challenge with getting the reasons why someone is declining a request to be part of the automation. Is there a way to allow for the u…Using Smartsheet6513Jed Rusyniak -
First post 10/30/19,Last post 10/30/19Can 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…Formulas and Functions81Brian_C
-
First post 10/16/19,Last post 10/21/19I 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 …Using Smartsheet179MB
-
First post 10/17/19,Last post 10/18/19I 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…Using Smartsheet161merrily
-
First post 06/26/19,Last post 10/14/19Is 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.Using Smartsheet152[email protected]
-
First post 10/05/19,Last post 10/14/19I 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…Using Smartsheet183hderryberry
-
First post 10/07/19,Last post 10/08/19I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date) I need to have the following result as an example Start date: 1/15/2020 Effective Date:…Formulas and Functions293ANA G
-
First post 10/04/19,Last post 10/06/19When 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…Using Smartsheet191CLuke
-
First post 10/03/19,Last post 10/03/19We 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…Formulas and Functions144Hugo Martinwall
-
First post 06/19/19,Last post 10/02/19Hello! 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…Using Smartsheet195RalphP93091 -
First post 09/30/19,Last post 10/01/19Hi, 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…Using Smartsheet183SBash
-
First post 09/26/19,Last post 09/27/19Hello 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…Using Smartsheet291Matt_K84
-
First post 09/24/19,Last post 09/25/19I understand on 9/19/2019 Smartsheet changed unlicensed user functionality. The send row function is now no longer working for a two users I share a sheet with. The function is grayed out and returns a message to upgrade to a paid level. …Using Smartsheet183Marie Chestnut
