-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
-
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…
