Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Gantt Charts
Discussion List
-
Schedule VarianceAccepted AnswerAccepted Answer James Pflueger 21 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/17/20,Last post 01/21/20How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…Using Smartsheet215James Pflueger -
First post 01/09/20,Last post 01/09/20Is 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…Using Smartsheet261Alyjon14 -
First post 12/31/19,Last post 12/31/19So...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 w…Using Smartsheet223LLaCosta -
First post 01/28/19,Last post 12/29/19Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates. So for example, we might…Formulas and Functions596samanthabooty
-
Baseline/Actual Schedule formula helpAccepted AnswerAccepted Answer Nick Monroe 45 views 13 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/19/19,Last post 12/20/19Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additiona…Formulas and Functions4513Nick Monroe
-
First post 12/05/19,Last post 12/17/19I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.Formulas and Functions522TRach
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
ilene_healy68056 22 views 2 comments 0 points Most recent by ilene_healy68056 Formulas and FunctionsFirst post 12/02/19,Last post 12/04/19Dear Community, Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entr…Formulas and Functions222ilene_healy68056
-
First post 12/03/19,Last post 12/04/19Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes …Formulas and Functions231Chuck Perez
-
First post 12/02/19,Last post 12/02/19Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this? (Image)Using Smartsheet181Mattias
-
First post 11/26/19,Last post 11/26/19I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…Formulas and Functions311bukkymoh01
-
First post 02/08/16,Last post 11/25/19I would like to apply smart sheet to my workstation for daily manufacturing status board. Is there any chance for me to change gantt chart scale from date to time.Archived 2016 Posts175Junho Kim
-
First post 11/20/19,Last post 11/25/19Hello everyone, I've been using Smartsheet to keep a timeline for my projects in Jira. So far everything has been working great but I noticed an issue when reordering rows. When I do this, after a few hours, the rows will return to thei…Premium Apps and Integrations222mavalos
-
Closed Sarah Link 17 views 3 comments 0 points Most recent by Richard Rymill SBP Archived 2016 PostsFirst post 04/14/16,Last post 11/23/19We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank …Archived 2016 Posts173Sarah Link
-
First post 11/22/19,Last post 11/22/19I created a basic project sheet and have been filling in tasks for two main deliverables (both shown as parent rows). Under those two parent rows are several child rows. However, the % Complete column is only auto-calculating for one of th…Using Smartsheet343snordman112306 -
First post 09/21/17,Last post 11/20/19Ok I don't know what other term to use...but on every dashboard the gantt chart reports have all reformatted themselves to make whatever column in the middle of the report HUGE...and shrinking the gantt chart part to a very small and kind …Archived 2017 Posts5350Bjohnson
-
First post 11/20/19,Last post 11/20/19So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have…Formulas and Functions364NaNa
-
First post 06/09/15,Last post 11/19/19Is there a way to hide weekends (or any non-work days) so that they don't take up width in the Gantt chart view?Archived 2015 Posts4416Tory Garcia
-
First post 11/06/19,Last post 11/18/19As part of my project I am ordering parts with multi-week lead times. I have 3 weeks upcoming that our business will be shut down but that will not affect my vendor's timeline. Can I remove a specific "task" from the project cale…Using Smartsheet292nick_cruz
-
First post 11/14/19,Last post 11/15/19I want to be able to view my gantt chart more zoomed in. Is it possible for me to have my primary headings as days and secondary as hours? Or is the furthest you can zoom in weeks and days?Using Smartsheet172Mjfreuland
-
First post 11/08/19,Last post 11/13/19I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to…Formulas and Functions111Ezra -
First post 11/11/19,Last post 11/11/19Hi, I'm new to Smastsheet, I have entered several tasks and sub tasks in my project, but they are not displaying in the Gantt chart. Any ideas?Using Smartsheet165Tonycu
-
First post 11/23/15,Last post 11/11/19I just started using Smartsheet for project planning. I have created a lot of tasks, put in the predecessors for each task, put in task durations and put in resources. The resulting plan shows that Person A is doing multiple tasks concurre…Archived 2015 Posts5317rowan.bradley
-
First post 09/21/17,Last post 11/10/19For groups of tasks, the overall heading bar for the group is always gray. I'd like to change it's color to signify status (red, green, yellow). Is this possible.Archived 2017 Posts386Doug Reid
-
First post 11/03/16,Last post 11/07/19I'm creating a Gantt chart to monitor and plan my progress for a thesis I am writing. I have the various stages of my thesis with their sub-projects indented under them, so my Gantt chart is becoming quite tall. I also need the days of…Archived 2016 Posts234Nathan Bourne
-
First post 07/24/19,Last post 11/07/19H Folks, For some reason I have areas in my smartsheet plan that have grid missing, some are ok. Does anyone have an idea how I can correct this and add the gridelines back please. thanks Mark, (Image)Using Smartsheet262Mark V
-
First post 11/01/19,Last post 11/06/19I have a "Date Completed" column in my list that I would like to roll up like Start and Due Date do with sub-tasks in the hierarchy. I have been unable to figure it out with formulas. So, I am looking for the last date entered in…Formulas and Functions149Lindsay AR
-
First post 11/04/19,Last post 11/06/19Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: (Image) …Formulas and Functions143grant53396
-
First post 11/04/19,Last post 11/05/19Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task…Formulas and Functions201shah
-
First post 11/04/19,Last post 11/04/19Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…Using Smartsheet333Ivana