-
Amount of Working Time Between Tasks
We have a desire to calculate the amount of work time between the end date of a task, and the start date of it's successor task. Before the update that included partial day durations, we were performing this with simple date arithmetic. Now, that arithmetic does not hold true, and we need to devise an updated formula to…
-
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
-
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column. For example: Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2 Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3 Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the…
-
Is it possible to Auto-Fill dates?
Hello, I'm sorry if this question has been asked before, but I couldn't find anything through the search function... I have prepared a template for event management. We use the same structure for every one of these specific events that we do (the event date is announced, and then we work back from the date to establish…
-
Resource Availability
I need to figure out a way to view resource availability for a given time period, besides just visually scanning the resource view. Is there a way I can create a report that would tell me the dates that a given resource is not scheduled/assigned to a task across multiple sheets, so I can assess that resource (or group of…
-
Dependencies by Assigned User
Can dependencies by automatically set by Assigned User? i.e. Fred has 5 tasks each will will take a day - can the start and end date be automatically set with dependancies?
-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
Gantt Chart - Is there a way to manually adjust a tasks start date without breaking dependencies ?
I'm creating a project schedule for the design and build of a new restaurant. The only concrete date that I know is the Tender date which is part way through the schedule. I filled out all the tasks and entered in the durations and predecessors for all the tasks. The problem is if I enter the date for Tender it only…
-
Gantt & Calendar Views on Reports
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…