-
Stacked Bar Graph
Is there a way to create a stacked bar graph with the new charts? Thanks! Chase
-
Reports with Gantt Chart
Is there a way to create a report from a project plan that only shows the gantt chart? I don't want any other information than a visual of the gantt chart.
-
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…
