-
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…
-
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…
-
Why is Gantt view not working for all items in a report?
I have a report that pulls from three different sheets. It uses Gantt view so I can track the status of projects I'm working on that come from three different areas. Gantt view shows just fine for all data pulled from two sheets, but not data pulled from the third. I'm not sure why. Please help.
-
How to set start date independent of predecessors?
Hi Community, I'm trying to figure out how to set a task start date without wiping out the predecessors but I can't figure out how? I've seen other posts with slightly different queries where people would simply suggest adding lag times or something similar so here's some additional info to show why that wouldn't work for…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Merged: Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
This discussion has been merged.