-
Resource Loading across projects
Hi, I have a situation wherein a developer is working across 3 projects, with his loading being: 1. Project1 - 50% 2. Project2 - 25% 3. Project3 - 25% When i plan his task for Project1, i need to ensure that he is only 50% and accordingly the duration for the task needs to be calculated. Is there any method where i can…
-
Sights & Gantt Chart
In my report, the Row description is showing on the gantt chart as I have set-up. However, when I look at the Sight Gantt chart it is gone. Also, my project starts in March and it keeps going back to January 01 for the display. This results in a lot of blank data that is useless.
-
Estimated vs Actual Time
How does everyone accurately document their Estimated Time vs Actual Time Spent on tasks for a project? Currently, in our planning process we assign a Start Date and an End Date for each task (with allocation %, duration, and predecessors for each task) once the person assigned to the task acknowledges and begins working,…
-
If then statement for Risk Management Matrix
Hi Folks - I'd like to feedback to write a formula that evaluates the following: =IF(Cell A1 "Acceptable" then??? Acceptable Tolerable Undesirable Intolerable "Then"... the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2,…
-
Trouble importing from MS Project
I get a master schedule in a XML file and the basic info all imports fine. There is another data field which won't import for some reason. It is a text field with essentially "assigned to" info. Any suggestions? thanks Bill
-
Date-based RYGB balls automation
Hi, For the past couple of days, I have been trying to automate my RYGB balls based on Target End Date and Actual End Date columns. I've been reading this article, but I cannot seem to get the formula right. These are the conditions I am trying to satisfy: * BLUE = if the Target End Date cell and Actual End Date cell are…
-
conditional notifications
I would like to know how can I do conditional notifications on my sheet? I would like to create notification when someone change any column other than (Owner / Assigned) will send out notification to that row (owner / assigned) instead of every user.
-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
Cards - Can we have support fro split columns
I was watching a video the other day on Microsoft Azure (https://azure.microsoft.com/en-us/resources/videos/242/). There they detailed the ability to have split columns under a single swimlane header. This allows you to further sub-divide the tasks within a category. Is this supported in SS? If not can it be as this would…
-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…