I need a sanity check. I just found out I know nothing about how holidays function in Smartsheet. My education came about I was making a "simple company calendar" for our intranet. And now I am facing…
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mi…
We have migrated a fairly complex plan from MS Project to Smartsheet and have been able to line up most of our dates. However, when Predecessors finish early on a task, the start date is impacted, as …
I have a background of using MS Project where 'predecessors' are the equivalent of 'dependencies'. I have got used to smartsheets pretty quickly and for the most part get along with it but feel that t…
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 pr…
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 peo…
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…
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…
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 bel…
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?