-
Merged: Add elapsed days in predecessor column
This discussion has been merged.
-
Merged: Gantt hour-by-hour
This discussion has been merged.
-
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…
-
Sharing Report but Not the Source Sheet
I would like to share a report, but not the source sheet. The source sheet has personnel information that I do not want to share with our customer, but I made a report with the information I am comfortable with sharing. However, when I share the report, it is blank because the customer doesn't have access to the source…
-
Gantt Bar with milestone
Would be extremely helpful for high level reporting to be able to have a parent row which is showing the overall Gantt bar be able to display a child row as a milestone marker along that bar. Our project portfolio would benefit from being able to show the go-live milestone that is occurring during the project execution…
-
Smartsheet XML export to P6 Import
I am trying to import into P6 the XML file from Smartsheet. The fields do not map correctly, for example start date maps to baseline start date. Also, Assigned Field in Smartsheet does not seem to map into P6 at all. I am working with 2 Smartsheets developed and owned by others. I am trying to use the Smartsheet info in a…
-
How to change and edit default time in Gantt Chart ?
Hi all, I am trying to track time for each task in a gantt chart by using the formula (=Start@row + ""). This formula displays the date and time for each task as shown in the picture below. The problem is its assigning the default start time for a task to 8:00 am and I am not able to change it. The project settings section…
-
Gantt Chart Display and Behavior - Open to today's date mysteriously gets unchecked.
After I have checked Open to today's date for my project setting, it gets unchecked in a couple of minutes. Is anyone else experiencing this? https://help.smartsheet.com/articles/765755-modifying-project-settings#toc-customize-the-gantt-chart-display-and-behavior
-
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…
-
Gantt view dates don't show correctly . . .
The dates shown in the Gantt view bars do not show line up with the actual dates stated in the Start Date and Finish Date columns - it is out of line by about 6 months. In the attached screen shot, for the overall project the Finish Date is 26/02/2021, but the Gantt bar shows the finish to be in middle of Q4 2021. It is…