-
Creating a cell link to a different sheet with different working days
Dear community, I have created a sheet for Data Center migration planning. By definition these activities are planned during normal working days (Mon-Fri) but the migrations happen during weekends, as it requires to stop servers and so that's the lowest impact to services. This sheet has defined all days as working days to…
-
Show Week Numbers on the Gannt Chart
On the chart you show the months, but it would be good to have a week number listed as well. ideally week from start of year and also the option to have a week number starting at the begining (start date) of the project to see how many elapsed weeks there are.
-
Adding checklists to a project
In my project with gant chartsd and ependencies, I would like to add a task, e.g., "Set Up Vendors". As a subtask, I would like be able to add 10 vendors. Ideally then, as each vendor is setup, I want to "checkmark" each vendor. Once all 10 vendors are checked, then the task can be marked as complete. Is this possible?…
-
How to make Gantt bar color dependent on condition: if a task is a child (subtask) of a selected par
I have created a sheet based off of the Team Task List by Priority template. I have changed the priority task names to reflect the names of our team members. This allows me to group the tasks by tech, so the sheet's description would more accurately be Team Task List by Tech. I had conditional formatting set up to…
-
cell linking for milestones
I have created a sheet for roll up of select rows only for sight using cell linking. I can't seem to get milestone icon. What appears as Milestone icon on regular sheet has come over to cell linked sheet as regular task. How do I get the milestone icon on the cell linked sheet?
-
Sight report - collapse and expand lists on the screen
Hi all, We're using Smartsheet sights for our weekly confcall on program progress in full screen "presentation mode", which is really doing great for us. One of the widgets in the sight is showing actual gantt charts per project and it gives us the right level of detail for the call. As the project list is growing rapidly,…
-
Due Date vs Traditional Start-End Dates in Gantt charts
I've used the Gantt chart functionality to good effect, although it seems to be a little too "smart" when you set up dependencies, durations, predecessors, etc. What happens is the dates get too rigid and "calculated", imo. So I'm doing a basic list of tasks for a 3-person team. Most of the tasks are not linked by a…
-
Critical Path View for Viewers
Is there a way to allow people with viewer access to a sheet to see the critical path on the gantt view? The project team would like to be able to view the critical path but not allow every person to have edit rights on the sheet. Any advice is appreciated!
-
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
-
What's the best way to show Baseline Schedule when it's not available on the Gantt?
We are using the Baseline "workaround" by creating the Actual Start, Actual Finish and variance column formulas. What method has worked for you to compare the baseline to the actual since it's not supported in Gannt view? *already upvoted this feature!
