-
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
-
How to get team involved
What are some ways that you are implementing Smartsheet into your company, team, etc.? I am the creator of the Smartsheet system in my company. I have found that because I have spent so much time in the sheet I have a gap between me and my team that is difficult to close. It all come down to how we get our people into the…
-
date calculation
I want to calculate the actual number of workdays from a scheduled start date and scheduled finish date but i keep getting the wrong answer. a project started May 9, 2016 and is scheduled to complete on June 16, 2016. My date calculation says that's 27 work days which is incorrect. the formula i used is…
-
Assigning Team Memebers to Task/Duration
Let say you have a task with a set duration, start and end date. The duration was based on 1 person doing the work but if I want to assign it to 4 people so it theoretically goes 4 times faster. Is there a way to say to smartsheet "This task has 4 people working on it" and for smartsheet to then adjust the duration, start…
-
How to automate Harvey Balls based on % Complete Summary Field
Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated. Thanks, Robert
-
Formulas in Smartsheet
Im trying to get a formula to work in smartsheet. Can anyone help me out? =IF([Travel Type]1, "craftworker"), ".3", ".4") I want it to apply $0.30 to the cell if the travel type selected is craftworker.
-
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
SUM formula does not provide a total of IF statement outputs
Hi I have a timesheet tracker setup with a web form (mobile) to allow me to quickly keep track of my daily activities etc. There is a basic formula setup to auto populate my mileage based on a site code that I enter. =IF(LOC8 = "Home", "00", IF(LOC8 = "KH", "90", IF(LOC8 = "NP", "110", IF(LOC8 = "BP", "110", "xx")))) I'm…