-
How to calculate elapsed time between status changes ?
Hello, Is there a way to calculate the elapsed time between two status changes ? I would need to know how much time it took for the status to change from yellow or red to green. Ideally, I would like to be able to calculate a mean per territory, department and my whole plant on time between yellow/red to green status…
-
Functional Requirements in Smartsheet
Hello, Our project team recently transitioned to Smartsheet. I am currently deciding how we will develop Functional Requirements (e.g. Excel, Smartsheet, Word, One Note, etc.) and eventually test cases. Is there anyone using Smartsheet in this capacity who would be willing to share their experience (pros/cons) and template…
-
Automatically Change "Modified by" email item into a Name
Hello! My team is creating a form to collect, track, and act on paid-time-off requests and part of the system we're creating is making a form for folks to submit their requests through. We need to share parts of the content of this sheet with multiple different parties so plan to create some reports and dashboards to share…
-
Workflow Process - Approval Level
Dear Sir/Madam, I would like to describe my issue below. We are going to create approval workflow process in on our company using smartsheet. Having multiple types of form (Smartsheet) in which some forms requires 4 level approval (including 1 verification) and some forms requires 3 and 2 approval level. For above case. I…
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
My Smartsheet Wishlist
I 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 context. These items are some of the things that would make Smartsheet even smoother.…
-
Volunteer Allocation
Hi 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 locations (we do not know these specific locations until last minute). I have built a survey…
-
Simplest way to update staff on onboarding tasks
My 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 options but wanted to ask if anyone had an idea on how to do this. Thanks
-
Counting and Averaging with Exclusions
Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the divisional sheet-level and the metrics sheet-level. Problem 1) Sheet Summary…
-
Calculating costs for a task over more than one month
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, Finish = Sept 5. So in my cost sheet, the formula needs to refer to the start date…