-
printing gantts, printing stuck on quarters
When I attempt to print a gantt chart, the printed version always shows the dates in quarters, even when I am viewing weeks or months. How do I get the printed version to match what I am viewing?
-
Dynamic Gnatt Options
My team's project management process creates various stages of a project; I'm curious as to if there's a way to color code those stages within a Gnatt view on SmartSheet. Prior to utilizing SmartSheet we did a manual gnatt chart(see attached) that showed a color status under a color coded timeline of the various stages of…
-
% complete based on count of child checkboxes.
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…
-
Add field to timeline
Hi, when using a gantt the timeline normally expands between the columns "Start" and "Finish". Now, I have a third and fourth column which I would want to be on the same time line, but not as one long marking. The time period between "Start" and "Finish" should be marked, but then it should be a space until the third date,…
-
Still no versioning?
Hi, I'm a new user to smartsheet and was considering going for the business license, however, I noticed a pretty big flaw in SmartSheet 4 days in. SmartSheet has no way of reverting changes. One of my team members accidentally deleted 59 rows worth of data, and had no way of getting it back. I found that SmartSheet doesn't…
-
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…
