-
Time Tracking
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
-
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…
-
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…