-
RAG indicator at parent level Vs Child
Hi All, I need help on a formula. In my current schedule the RAG is determined by % complete of task, desired% as on today and low tolerance. Here the parent level is indicating RED although child is in green and blue but no RED. Probably due the Desired % is more than the actual % but the actual % for child task is more…
-
Gannt chart help please
Hi, i'm using the excel template which smartsheet provide here: https://www.smartsheet.com/top-excel-project-plan-templates in the file ive downloaded the gannt chart looks lovely, however when i add in my project plan which has loads more tasks than the example, and over a greater time period the gannt chart severs no…
-
For a Project Portfolio Roll Up, SUM of Total Budget IF Project is Active/In Progress
I'm using the Project Management Office template set; however, it does not come with Budget totals, health, etc., like it does for the Schedule. I had no problem adding budget info for individual projects and displaying them on the project dashboard. I am now trying to get this information to roll up to the Portfolio level…
-
Protect Workspace Sheets From Being Copied
Good Day to Everyone. I have created a project management structure (folders, reports, dashboards, schedule, risk/actions. etc) that I think is fairly thorough and reasonably simple to use. I have invested a fair amount of time in developing this. Is there a way to protect it from being copied by people I share it with?…
-
SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0. SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row) =SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row,…
-
Can Smartsheet forecast end date base on % complete input
For example: Start Date: 10 Jan 2022 (Mon) End Date: 14 Jan 2022 (Fri) For simple calculation, working day duration is 5 days. Each day should achieve 20%. Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%. Therefore I will need an additional one day to complete the task. So the forecast end…
-
WBS Formula Question
I was hoping to get some help with a question regarding the WBS template from SmartSheet I found this template very helpful, and I would like to use it for my projects, but I need a little assistance with modifying the formula. I am not sure if this same setup can be used when the project tasks don't start on the first…
-
Check a box when a match for a value is found on another sheet
Hi everyone, I have a sheet called Parts Database used to track parts as they go through a production process. Screenshot below. Currently, workers check off the status of each part as they go, which is not practical with the quantity of parts. Ideally, I want them to be able to fill in a response form at the end of the…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
# of tasks based on due date and owner
What Smartsheet formula would be best to get the count of tasks due within 10 days if the owner equals "client"?