-
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?
-
Does a range of dates fall between another range of dates?
Hello, 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 have a number of projects running throughout the year across different clients and…
-
Baseline/Actual Schedule formula help
Hello 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 additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Changing Drop Down Value Based On Current Date?
I 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.
-
Forcing duration and start date to a specific value on Gantt
Dear 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 entry to automatically make the Start Date match the End Date and ensure that the Duration…
-
Rostering for Global Customer Support
Hi, 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 our contractual obligations with customers in an easy display view to the eye. Do you think…
-
Creating a PMO functionality
I 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 all the info that's updated in the individual trackers feed into. This master tracker…
-
gantt chart using time as a scale
I 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.
