-
Project Health formula Help needed
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green")))) These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time. If scheduled end date is…
-
Sample Data Center Project Plan
Shot in the dark - but does anyone have a SS data center migration plan they might have used that you would be willing to share? I am trying to determine if such a large scale project would work using SS. I've looked on PMI for samples but did not find any. TIA.
-
Alert Task Owner when change is made by someone else
Hello All, I have a task sheet that is shared with multiple users. I have a field for the name of the Project Manager and a field for the name of the Task Owner. I would like the PM to get an alert when the row is updated but only if the update comes from someone other than the PM. In other words, if the PM is updating the…
-
Formula to change status symbol if a task is not completed before due date
Thanks guys, new to Smartsheet and need some help... Having issues with changing the status symbol to Red, Yellow, Green, or Gray based on project completion percentage column (%Complete) and start/due date columns ("Start Date" / "End Date"). I would like the following: Gray - If %Complete equals to 0 and start date has…
-
Task duration as a function of the number of resources
Hello! Can task duration be calculated as a function of the number of resources? If one person takes three weeks then allocating three people should complete the task in one week, etc. This should be easy but I can't find this capability. I'd appreciate suggestions on how to do this. Thank you, Michael
-
Is there a way to update source sheets for multiple reports?
We created about 30 reports. Each of them is taking the data from multiple sheets (each sheet is a project that our team is working on.). When we add a new sheet (new project), we have to go through each report one at a time and add the new sheet to the source data in the report template. This is very time-consuming when…
-
Add date to formula
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please…
-
Manpower Projections w/ Multiple Schedules
I have several projects and we are inserting the schedules into Smartsheet and linking those with various sheets. One thing I would like to create is a sheet that pulls in Crew Size from each job and for each date range display the labor needed. In each schedule, I placed a column for estimated hours and then used a…
-
Generic timeline on Gantt chart
I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
-
Options to show multiple project plan sheets into one view
I currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Has anyone tried to do this before?
