-
Calculating Durations
I have columns in my sheet with "Departure TIme" and "Arrival Time" in the format hh:mm Since there is no "Time" Type for the columns, so I had to kep the Column Type as Number/Text I am looking for a way to substract these 2 columns to obtain the duration of the trip. Many thanks for any help
-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
Is there a way to round up in 15 minute increments in Smartsheet?
Is there a way to round up in 15 minute increments in Smartsheet? What's the formula for it if I can? I know there is a roundup formula but that doesn't allow you to round up in 15 min increments.
-
Payroll
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
-
Row Update Request recipient delete attachments?
We have built our Employee Annual Evaluation process into Smartsheet. While we have very tight access privleges on the Roster where the info is stored (HR personnel only), we are utilizing the "Update Requests" to the supervisor in charge of completing the evaluation. While Smartsheet manages the workflow/process, the…
-
Automatic Staff Details
Hi All Is it possible to have detials auomatically filled in for a person. Eample i select person x from a drop down list to work on a course, the spreadhseet then gets the phone number and email adress of person x from a sperate spreadhseet and auto fills it. Thnaks in advacne for your help. Matt
-
Asigning special dates in Time Line Display
What I try to make is: E.g.: There is a task for the time between Aug 5th 10 and Aug 18. On Sep 14 partner XY is required to be present in City AB. Is there a way to show the alert icon in Time Line Display linked to additional details? The notification is already possible and the message can be sent to appointed person.…
-
Can you schedule a report to run?
Hello, I just recently setup some sheets to help with payroll which tracks piece work (we're a manufacturing shop). They input the date they did the work and the number of pieces (I've built a sheet with every single part on it and put their respective price per part that calculates the total for that part). There is also…
-
How to send a notification to a selected recipient
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
-
Conditional sharing of row data from one sheet to another
We have divisions that have an HR function. Each HR function has their own Smartsheet to monitor salary action data. Certain salary actions require approval from the Central Office. Is there a way to conditionally share specific rows from a Division Sheet onto a Central Office sheet? It seems the only way so far is if the…
