-
Project Sheet nested checklist without duration and dependency
Hello Community, I would like to nest a short checklist of rows under an activity in a Project Sheet such that the nested rows representing the checklist do not require durations and dependencies. However, SmartSheet requires the duration and dependency on each nested row, where I repeat the same data, so it rolls up to…
-
Need Guidance - Can you develop a Generic Project Schedule in Smartsheet
Can you create a generic project schedule in Smartsheet? For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and ends Day 90 (end of month 3), Task 3 starts Day 31 (start month 2) and ends Day 180 (end month 6), etc. In Gannt View, you…
-
Gantt - Task Name, Start and End Date
Hi...I would like my gantt chart to show the task name, start date and end date. Is this possible?
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Cannot change the start date of a whole project
Hi, I have a project with some linked predecessors in it, but some events without. I am trying to make the whole project start later and keep all the relative dates and dependencies. I cannot select all events and drag - I see lots of arrows that seem to loop back to the beginning. I tried creating a new date column with…
-
Work week & calendar days on the same sheet
Hi folks - can anyone tell me how I can have a combination of start/end dates that have standard work week durations (Monday thru Friday) as well as efforts that take weekends into consideration (all calendar days)? I know how to make the Gantt dependencies reflect one or the other but cannot figure out how to make 1…
-
The option to change parent row calendar colors when dependencies are enabled
I have several tasks in each of my sheets that I want to see in a report for major milestones. I want the different tasks to have different colors. Right now it is possible to change the color of children rows on the Gantt Chart/Calendar view, however when dependencies are enable, it's not possible to change the color of…
-
Changing outlines of Gantt chart bars
Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the outlines? Thank you very much! Kind regards Ulrich
-
Gantt chart & conditional formatting
Hi! Currently the conditionial format of gantt Chart bars is limited to the format option "entire row". As we use the entire row format for visualize the sheet structure (levels), it would be nice to have also the bar Color depending on a single column. Kind regards Michael
-
What is the best way to consolidate data from multiple sheets?
I have multiple projects running side by side and I need a method to view a high level overview of all my projects with real data and a Gantt chart. I know I can use reports but reports do not support Gantt charts or a calendar. Does anyone have a better solution for how to do this?
