-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Worksheet for Employee Referral Program
Hi Community, Would like some buy-in from the community to see if anyone has created really great employee referral program sheets that have helped their business? I'm sampling some of the templates arlready in SS, but thought I would see if anyone one else had some awesome sheets they'd be willing to share. Thanks, Kris
-
Recruiting Metrics
Hi SmartSheet Fans, Wanted to start a discussion with the community revolving metrics and how you've used SmartSheet to get you recruiting metrics (time to fill, 1st touch date, etc.). Since everything is date related we created formulas to help us, but would love a different approach if anyone has any. Thanks! Kris
-
Will adding Data unto Webforms be added automatically to the spreadsheet?
How do I get the data I entered on a webform to get added unto the spreadsheet I am working from? Can I do both or does it have to be either 1. use the Webform or 2. enter data unto the spreadsheet?
-
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