I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
Hi How can we prepare the baseline chart to show each projects Original schedule and current schedule . Thanks
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique…
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on. So what I'm looking for is…
Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this subject.
I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
In MS Project I often used subprojects and could easily reference them in one row of the WBS. So, I looked for instructions on how to do this and the most relevant hit suggested that "phases" be used. However, the help instructions are either wrong or I am not interpreting them correctly. The instructions say to add a…
How would I write a formula to automatically populate a status column with red, yellow, or green based on where the project is at? In the screen shot below the Implement Asset Works is on-track because the gantt bar is filled in to the dotted line. The Implement Salesforce is behind schedule since the gantt bar is only…
