-
HELP - Creating dependencies but using start-date instead of lag
I am building a plan with my stakeholders, we have a number of sprint-based tasks that have dependencies. It is very painful to constantly use the 'lag' function for all of these. How can I:1. Link activities using dependencies so they can be visualised in the plan. 2. Allow me to put in a start-date for the successor…
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
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.
-
Gantt View on Dashboard not starting at today's date
Hello! I have a report that summarizes deliverables from several sheets, with the information displayed in a Gantt view. On the Gantt Timescale Settings, the checkbox to open the view to today's date is checked. I created a dashboard and have the report on it with the Report Widget. When I load the dashboard, it properly…
-
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…
