-
Dates - Gantt Chart
I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End Date]$136, 3, false). The…
-
formula for the %completion in parent
Hi All, I am trying to replicate the %completion formula in googlesheets in order to understand the value of a project based completion of the various subtasks. Does smartsheets have this ability inherently? The project guys always think they are further along on the project than they actually are and this is artificially…
-
Critical Path Task w/o Critical Path Predecessor - Is this even possible?
I was reviewing the critical path of a project last week and saw something odd. Perhaps I'm mistaken, but I believe I saw a critical path task that had no critical-path predecessors. Is that even possible? The image below shows how I have a task in red color within the gantt, but no red lines leading to it. (I checked -…
-
Charts
Hi Guys, Literally just started on Smartsheets, I have created a RAID Log template and was hoping to create a dashboard that would complement my log. Unfortunately every time I try to fill in the data the system tells me my data is invalid. Could you help me how to make this DATA fit in some sort of chart. I know this is…
-
Gantt Chart Start & Finsh dates Change
If my Start or Finsh date changes from the orginal schedule how can we show the progress or delay in the schedule. Currently I'm re-entering the Start or Finish date. So I'm lossing the orginal to show us any gains or losses. I do not want to loss the predecessors link to the task.
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
-
Allocation meeple appearing without any concurrent task
Hi, I got a mysterious meeple over-allocation icon that I have check numerous times did not any have a concurrent task. As I interpret the allocation icon, it means I am doing many task as the same time on which numerous occasion I can clear it by changing the schedule or dividing the task to subtask or phases with…
-
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