-
Integrating non working holidays on another country
Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China. I think many of you have been affected by week long holidays like Chinese New Year week. Is there a way entering a certain countries holiday without making it…
-
More than one Baseline + Comments
Dear all, To enhance Smartsheet as a comprehensive PM Application, my company and I find that a crucial feature, baseline management, currently needs to be added. While the ability to set baselines is valuable, the limitation of only being able to set one baseline is a constraint. We propose the implementation of a feature…
-
Bah Humbug! No holidays for you. (None of our projects have holidays)
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 some problematic implications. Please confirm my understanding below. Situation: We use control center to provision…
-
Viewing team capacity over time
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 mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Is there a way to set a constraint on a task's Start Date that can override a predecessor?
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 expected. In MS Project we can use constraints to say the next task cannot start early even if its predecessors end early.…
-
Is there a way to move a dependant date further out without using lag?
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 there is a definite limitation when using dependencies as follows: In MS project if I have line 1 completing 28/11/23, I can…
-
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…
