-
Mark which task is the deadline?
I have a set of tasks in a schedule to prepare for a software release - which is the ultimate goal and deadline we are working towards. I want to see the critical path for this release. But, I also have some tasks in the schedule of things that need to be done after the release, and Smartsheet is showing me the critical…
-
Setting milestone to Finish date?
Is there any way possible to set the milestone marker to the Finish date in a sheet? Right now, I'm still having to manually set the Duration column to "0" to get the milestone icon, but even when I do that, the date of the milestone gets set to the Start date.
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Time of day
As an event planner I need to assign start and end times i.e. 9:00 a.m. - 3:00 p.m. to meetings and tasks that need to be completed. I can obviously type in the times, but they do not sort correctly as anything starting with a "1" regardless of AM or PM will shoot to the top. I can put a "0" in front of any AM times, such…
-
Gants - Resource allocation, Assigned Groups.
Hey there, new to Smart Sheet and have a question. I'm building gantt charts for some of our projects. I’d like to be able to account for the amount of people that belong to a group/resource to properly scope the amount of time needed for each task. For example, one task within the Gantt would be ‘Fabrication’ – I assign…
-
Start Date Autofilled by End Date and Duration
I'm building a construction schedule for cabinetry across multiple projects my company has going. Is there a way to dictate a start date, date the vendor needs to start working, by the known building/finishing time and the end date, date they need to be on site. I.E. I'd like to put in the end date: 1/22/18 and a duration…
-
Completion Status Bar with the Task Bar
This is a fairly straight forward question and I think I might know the answer, BUT here it goes. The completion status bar within the task bar is typically driven by the % Complete column. It appears that column (for the bar to work correctly) has to be manually entered. If I use a formula, it will give me a % but will…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
Dashboard Gantt for Extended Period Task Prevents Display of Current Dates
For a leadership dashboard, we have a report with a list of current projects. We want to display the Gantt chart on a dashboard. One of the projects began on 8/4/2015. The Gantt timeline begins in August 2015 and can scroll to the week of March 17, 2019. Given that it is May 23, 2019, this is a no-go. Workaround ideas? My…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
