-
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…
-
Gantt Chart view for Daily / weekly / monthly Scheduled works
Hi all, We are new to this amazing product. We have separate 9 sites that have numerous different types of scheduled maitenance required at different times. Is there a clear way of displaying this in a gantt chart or spreadsheet type of format? example - Daily clean, weekly service, monthly polish, yearly audit. Thanks in…
-
FF dependecy to push Finish Date, while holding Start Date
Let's say I have two activities, A & B. A has a Start of 3/1/2016 and did indeed start on 3/1. However, it cannot finish until B finishes. So we put down B as a predecessor to A with a FF dependency. The problem I'm seeing is that as B Finish Date gets moved around, the Finish Date for A also moves, which is great; but the…
