-
Gannt chart start date does not match the date column
Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, but the gannt displays the bar starting at 8/14. I dont know if this is related, but the scheduled start…
-
Formula to calculate date
Hello, I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of the tasks automatically. For example, send agenda to attendees 2 months prior to the event. I've tried playing with the…
-
Gantt chart that overlays multiple projects
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a way to accomplish this?
-
Overall Total % completed
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% completed so the Top row should show 25% completed. But Not sure how to accomplish this? Each…
-
Gantt - Progress Ahead or Behind Schedule?
Hi All I'm keen to look into options to report on project progress against schedule. Generally we set a project programme, then progressively update %Complete against lines and the project progresses. The progress bar works well as visually indicating if each activity is ahead or behind the current date. I'm looking to try…
-
Complete Through Progress Bar
My organization is moving from MS Project to Smartsheet and there is a functionality on the progress bar of the gantt chart in MS Project that I would like to see if Smartsheet can do. The Update Progress bar that shades % Complete in MS Project can be set to show Complete Through progress (the functionality is detailed in…
-
Returning Start and End Dates
Hi All, I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled. I would like to return the MIN Start date in the Start Date Metrics column row 3 in image 1. The range is the Actual /…
-
Resource Management Tool
I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learnings they can share with me please? Also, attached is a screenshot of the resourcing…
-
Need help with 'If , Then' function to subtract Duration Values
I'm setting up a Construction Schedule with Variance calculations as the 'Near Term' baseline solution that's been quoted as coming for a few years now has not materialized yet. Unfortunately after searching the forums I'm not seeing syntax examples that work for what I need to do. It would be helpful for me at least to…
-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
