-
Gantt Bar Conditional Formatting not performing as expected
Hello Community, I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars. Here is my conditional formatting You can see below that I specify a change in row color and Gantt bar color based upon values in booSummaryRow. The…
-
Non-working day shading in Gantt not consistent
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have no formatting and some have the grey/white formatting. Why do some have it and others do not. I cannot find a setting for…
-
Changing % complete using a formula in another cell
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column with drop down values of Not Started, In Progress, and Complete. I would like to change the value of "% Complete" when I change…
-
Percentage increasing by 100
Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange thing is, this is only happening for one of my team. When i do it, in the exact same…
-
How to import/merge 2 Smartsheet projects plan into 1?
I need to import an existing project plan (call it A) into an already project plan (call it B). A is under a different corporate account than B. I have access to both. I need to merge the 2 project plans into 1. The question probably has been asked but I can't find a "real" answer. Thanks for your help!
-
Dashboard Report Widget: Columns Content and GANTT aren't in the same line
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is only when presenting in the widget. Is this a 'feature'? Thankful for any help
-
One Dependency for the start, another for the end?
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that continue after the on-site work is done, but I won't have to continue the update…
-
Build Gantt Chart based on JIRA User Stories Story Points estimations
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story points = 3d 3 story points = 5d ... Theoretically it is possible to build a gantt chart of the N user stories as follow User…
-
Color Coding In Progress Tasks within a Specific Time Period in Gantt Chart
Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional formatting to fill the cell background of tasks with specific start and complete…
-
Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )
So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and we want it as a 1-pager. Thoughts? Ideas?