-
Is there a maxium number of characters for the gantt bar label?
Hi anyone, I have a custom Gannt bar label set using the gantt timescale settings from a helper column that concatenates some information about that task. This can get quite long, especially if the project name is long, and I'm finding some labels cut off. Is there a maximum length (it seems to be 73?) or am I missing…
-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
-
How to change Gantt chart background color
Hi all, I used a Smartsheet provided Gantt chart template for projects. The default background color for the Grid view (and possibly the Gantt chart as well, don't remember) was the royal blue you see below. I changed the Grid view background to white so the font color could default back to black and minimize the wide…
-
Gantt Chart Colour - conditional formatting
Hello, I would like to have my gantt chart view coloured by the status colour. I don't want to have the whole row in e.g. green, only the task. I can do this by manually formatting the colour, but not automated, or at least I am unable to figure it out by myself. Is there a way of setting the auto-colour of the task bar to…
-
Flagging a Date and Time Overlap Across Multiple Days
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see below, I have different columns: Start date, end date, start time, end time. Start and finish are just switching the time…
-
Print Baseline
Currently there is no option to add the baseline when printing- upon research it seems that for some reason this isn't an option. Can we get an option to add the baseline when printing?
-
Annotation
Often when doing a delay analysis or some other schedule work, we need to annotate the Gantt chart to highlight certain areas, add notes etc to give the data more impact. Currently this has to be done in another program like PDF, can Smartsheet make such an option available?
-
Vertical line in Gantt - Data Date
It would be great if there was a way to add a drop line on the Gantt view i.e a vertical line that communicates important information like the data date i.e the date the schedule was updated These visual tools are important for consultants when trying to communicate data to clients etc
-
Visually demonstrate delay
When doing presentations its critical to be able to visually communicate delay. Currently in Smartsheet we can turn on the baseline to see planned vs actual however it is very limited i.e no ability to change the colour of the baseline, show durations of delay with an arrow etc. To be able to compare activities from one…
-
Ability to allow all users to set the "open to today's date" Gantt view option
This option should not be restricted to Administrators, but should be able to be chosen for all users, or at least Editors. Thanks Simon
