-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…
-
Flagging a double booked room
Hi Guys I have a tracker that my team use to manage their daily tasks. However, due to COVID there can only be a specified number of people in a room at a certain time. Often rooms have been double booked, resulting in work being delayed. I want to highlight whether a room has been double booked on a specified date by an…
-
Planned dates and actual visible on Gantt chart
I'm expecting my next project to be subject to a lot of external influences and dependencies. When faced with this challenge I like to show the original plan and the actual / newly forecast start and end dates to report upwards effectively and discuss the any slip. So in effect each activity has an "originally planned"…
-
How do I calculate the difference between 2 dates?
Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no?
-
link hourly rates to project schedule
I would like to link my artist's hourly rates to tasks in a project schedule to get an estimated hard cost. How do I do this?
-
iOS 13 and SmartSheet
For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neither does the mobile version of Safari in iOS 12. Please let me know your experiences so…
-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…
-
Auto Functions w/ Update Requests
Hello, I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a "report" of updates (children rows) with the update requests so the person who the task is assigned to can see their previous updates. As of right now I add a new child row…
-
Critical Path Not Working
Have set this up per the instructions (dependencies, predecessors etc.) but it only shows the final 4 activities in my plan as critical path which is useless. Anyone know why nothing earlier in my plan gets picked up?
