-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
General timeline for Gantt view
Hi Smartsheet technical team, Very often similar projects or recurring projects follow the same time schedule where specific dates are unnecessary. It will be good if the Gantt view can show a timeline without specific dates and that will give a general overview of the timeline to all stakeholders of the project. Thank you!
-
Representing Multiple Phases on a Single Gantt Chart Row
Hello Smartsheet community, I’m working on a project where I need to visually represent different phases on the same row of a Gantt chart. For example, I have a project that runs in three phases: Phase 1: January to March (Yellow) Phase 2: March to June (Green) Phase 3: June to July (Red) Is there any native solution or…
-
Merged: Representing Multiple Phases on a Single Gantt Chart Row
This discussion has been merged.
-
is "export gantt to image" completely broken?
The text looks terrible on the image when i select this option? I need it to be an image to insert into other documents.
-
Timelines - multiple work streams
We need to collect, and summarise timeline info in several streams a) Activities by group, relating to their workstreams (seasonal busyness) b) Org wide activities (i.e.long term and annual plan etc), c) External factors relating to staff availability (school holidays etc) This is to aid in selecting best timeline to…
-
Daily Reporting to Document Generation
Good Afternoon, Our construction firm utilizes a standard Gantt chart sheet to track our project's daily reports. Under each category of work we have milestones, i.e. Carpentry :: Framing :: Drywall etc. Under each milestone we add a child for that days work, i.e. Drywall :: Day 1 - Mobilized :: Day 2 - Started Hanging…
-
Conditional formatting doesn't work on Gantt chart
Hi, I set up the below conditional formatting. As you see it works for the row formatting but not for the task bars. It doesn't have any children rows. Any idea what might be going on? Thank you!
-
Allocate tasks to non-existing team members
It's very important at the beginning of a project to put together a plan speculatively, to identify additional team members we might want to hire/contract work to. I don't seem to be able to do this - typically I write a placeholder for the new hire (e.g. 'PCB engineer 1'), and it would be great to see the resource…
