-
Milestone task child in a % complete parent roll up
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
-
Setting up Project Management
Hi - I am creating a project management template for events. One of my tasks is sending out emails to customers. We don't send emails on Mondays or Fridays, so if I build out my dependancies, is there a way to exclude Mondays and Fridays only for those rows? I know I can set up parameters for the project but can I set…
-
Enhancement Request - Conditional Formatting on Gantt Bars
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
-
Non-working days are no longer greyed out - Bug?
Hello My smartsheets are no longer greying out the non working days for me, even though I have specified sat/sun are weekend (first image). I have tried clearing formatting but it doesn't fix it. My colleague sees the non-working days when he opens the same sheet. I also can see them in the background when I click 'edit…
-
Gantt chart top level visual summary of dependicies?
Hi, Is there a way when you collapse a top level item in a gantt chart to see colored shadings of the dependencies within IN that top level overall grey bar? Let them take the color from the assigned color of the dependency? For instance, I have 4-6 items within an entry but I don't want to expand the entry just to see…
-
Need Help using the function WORKDAY
Hi there, I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits? Thank…
-
Duration column
I seem to have deleted the duration column from my spreadsheet and can't work out how to get it back! Can anyone help... thanks
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
Sharing Filtered Gantt Charts
I want to share a filtered view of a smartsheet (gantt chart enabled) that shows: * dependencies and parent/child relationships that the user can close and open to help them focus on what they want. If I make a report out of it, I loose the parent/child functionality and the dependencies aren't displayed. I'm resorting to…
-
Gantt Chart has some lines that are all gray
Hi, I am using a fairly simple Gantt chart. it has 15 task rows in it. All tasks contain a Start and Due Date. The only indentation I'm using, is that I've got a "Project Launch and End Dates" row as my first row, and I've got all 15 rows under that, indented. The first 6 rows of the Gantt chart look normal. I see the…
