-
Ressource Management
Within a team of 13 users in Smartsheet, we are struggling with the resource management and allocation of tasks. If I want to allocate a task to a staff member which will require 30% of his or her time over a period of 2 months (but without knowing when he or she will work on this precisely), how can I do that ? Also, if I…
-
Approval process automation
I'd like to create a workflow which will collect data from a webform (can I edit the look & feel of the web form UI?) and have that data forwarded to several people for approval without the need to go to echosign. The webform is the easy part (thank you Smartsheet), but the rest of the approval confirmation on the sheet…
-
Hover over column to reveal full title
this would be helpful since I have some columns with long titles but the values are small numbers so the width of the column truncates the text... it'd be nice to be able to hover my cursor over the column header to see what it is.
-
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.
