-
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…
-
Project Management, If then Statements
Hi, I was wondering about Project Management using Smartsheet. I am trying to create a project where there are many options or collateral pieces that key stakeholders can request from our marketing team based upon the amount of ROI projected and what they rank. E.G. Gold= anticipated $$$ Silver = $$ and Copper = $ If they…
-
Images won't print with Gantt Chart
Looking for help - My uploaded images are not displaying when I print in the Gantt view. They do display as expected when printing in Grid View. Tested in multiple browsers: Chrome, IE, Edge
-
Can your event span time in calendar view?
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
-
Automatic update of adjacent columns
I have a % Complete column and a Status column adjacent to each other. I would like to automatically set the % Complete to 100% if I change the Status column (drop-down) to complete. Is this possible?
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Using the Project Management Dashboard Template
Hi all, I'm a newbie to Smartsheet and am evaluating its use within our organization and so far I like what I see. As a PM one of my tasks to do project status reporting and so I had a look at the Project Management Dashboard Template, this is a good basis for what I want to do. However, if I update the task dates in the…
-
Gantt Chart Formatting Gaps
Hey, I have been making some project programmes for my boss to present and there are occasional (seemingly random) lines running down the gantt chart. Some are at the end of a week some are at the start of the week, they are all of different widths. When the chart is exported and printed it is very distracting and I don't…
-
Resource not appearing in Project Resource View
I have a smartsheet that is being used for resource allocation. For some reason one of the resources does not show up in Project Resource View when clicked in the Gantt, any ideas? In the Gantt itself he does show up.
-
Change task Duration based on a condition in another cell
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
