Human Resources
Discussion List
-
Update field in another sheetIn Using SmartsheetHi 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?
-
Project Approval Received / Master Project Sheet PopulatedIn Formulas and FunctionsI'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…
-
Attempting to convert data from check boxes to Multi Select DropdownIn Formulas and FunctionsThank 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…
-
Date formulas - MonthsIn Formulas and FunctionsHi - 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!
-
Report not Matching Formula IssueIn Formulas and FunctionsHi, 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: You w…
-
How to add "Reasons Why" to the Decline action of a Approval WorkflowIn Using SmartsheetI 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…
-
Calculate Date Employee turns 18In Formulas and FunctionsCan 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…
-
find and replace text in an already created update request.In Using SmartsheetI 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 …
-
Checklist Form to Upload docs to DropBoxIn Using SmartsheetI 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…
-
InventoryIn Using SmartsheetIs 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.
