-
Gantt Chart Shows Completion Bar but not number
I am trying to have my gantt chart show the visible %complete in number form rather than having the bar go then %length as it is much harder to determine how far along it is for shorter tasks. I was wondering if there was a way to have both, as I would like to have it be easily scanned
-
Can I show critical path on select rows within a project plan/gantt?
I have a master project plan with many smaller projects within and would like to highlight one of them and just show critical path on that portion.
-
Line # Reference in Report
Good morning, Is there a way to show the original line number from a timeline to a report? I have a timeline Gantt for a project in one sheet. I have a to-do report based on the due dates in another sheet. In the report, I would like to reference the line that the item is found on the original project sheet so that it can…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Gantt charts and Dashboards
Hi. new here to the forum; recently created a Smartsheet Gantt chart and subsequently integrated it into a Smartsheet Dashboard. Looks great except --- I seem to have lost my indentation of my subtasks under a parent task, and that makes reading the results a lot more difficult. The other thing that I'd love to do is to be…
-
Show dealy in gantt chart
Hi We are trying to use Gantt chart, for planning a project timeline. We have expected start, actual start, planned end date and actual end date, because sometimes something gets in the way and we can't hold the original timeline. But we want to know how much of a delay we have or doesn't have. So we use the dates to…
-
Is there a way to Edit when a Quarter (Q1, Q2, Q3...) starts in SmartSheet GANTT Tool?
As of right now, I can sort my GANTT charts including QUARTER data on the header. (Q1, Q2, etc.) But it always assumes that the first Quarter starts in Jan: My company's Fiscal Year starts in Oct. So, my Q1 is OCT-NOV-DEC. Anyone knows if there's a way to tell Smartsheet to use my configuration for Quarters instead of the…
-
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
-
Printing filtered Gantt chart
I've got a large construction programme on a gantt chart and I am able to filter it to individual contractors (using 'assigned to' column). But I can't find a way to print out the filtered programme to just show each contractor their tasks to assist them with resourcing. Is there any way to do this ? Thanks in advance for…
-
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
