-
Populate Dates Between a Start Date and Finish Date
Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a basic start date for the job, and a finish date for the job. This shows it nicely on the gantt chart and all the days that are…
-
gantt chart - dependencies that are not necessarily SS or FF (or any other combination)
I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…
-
Gnatt View print
Dear All, I have a quite a large program plan. To have a level one plan, I have a column with a check box to indicate what needs to be shown in the Level 1 plan. On filtering the Checkbox the Gnatt Chart view shows the dependency links, however when I export the same to PDF view the dependency links disappear? I have tired…
-
Highlighting/Colouring Sundays in Gantt Chart
Hello, I want to colour all Sunday columns in a different colour than Monday to Saturday in my Gantt Chart Just like in the following Image; there are the Saturdays and Sundays with a grey background. EDIT: Okay, I got the issue. I also highlighted the rows of the main-tasks and its child-tasks in several colours (Task 1 +…
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
Gantt Chart Revenue Forecasting
I've built a sheet with all of our active projects and am wanting to predict revenue. I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and…
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
Net duration between 2 dates AND times
Hi folks, Ok, this is a tricky one: I'm trying to set something that was requested by many people on this community forum - a NETWORKDAYS that can account for TIME as well. In other words, the amount of working days/hours between to periods (that accounts for. There is this amazing…
-
Project Roll Up
Good Morning, I am struggling with presenting a project roll up including gant in a clean view. I would say a program view is what I was wondering if anyone had some guidance on. Thank you. Lynn
