-
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?
-
Integrating Gaant View Items and Calendar View
I'm having an issue finding a solution for meshing Gaant charts on individual sheets and multi-sheet calendars. On individual sheets we have "Phase" dates, these are anywhere from a few days to a few months. These are great for the Gaant view. The group calendar shows all the items from the individual sheets, including…
-
Trying to accurately gather % complete based on statuses and excluding N/A in children rows
Hi all! I am revamping a project task list template that my team uses each time we are building a new location. We'd like a high level completion status for each department involved in these projects, but I'm running into a bit of a hiccup with my formula. In the Status column of the departmental parent rows, I am using…