-
How to prevent entire Gantt timeline from shifting when updating activity dates? (Float reduction instead)
Hi everyone, I’m looking for some guidance on how Smartsheet handles float and dependencies in a Gantt project schedule. I’ve built a Gantt plan with several tasks linked through dependencies, and I can see the calculated float/slack between activities. When a small delay occurs on one activity, I update the start date to…
-
Successor tasks have mysteriously changed to start the same day predecessor ends
While reviewing a timeline created several days ago I realized that successor tasks are suddenly starting the same day predecessor tasks are ending. For example, Task A ends on 4/10/26 and task B begins on 4/10/26. Previously, task B would begin the following day, in this case 4/13/26 because Saturday and Sunday are non…
-
How to recover deleted calendar from Calendar App?
My colleague accidentally deleted a calendar I created in the Calendar App that our team shares. How can I recover this? It's not in our deleted items. I do have the URL, currently seeing this error: Oops! The page you were looking for doesn't exist. (ErrorCode: 404)
-
Auto Create Schedule Based on Needs
Does anyone have a template that can create a schedule based on needs? For example: we enter the number of contacts calling us per hour per day and how long the calls take, how long it takes us to answer, the service level we want, list of full time and part time techs with their normal hours they work and a two week…
-
Predecessor #REF Error
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
-
Is there a way to turn off these lines?
The gantt is looking too clutter for our liking. Is there a way to turn off the connectors lines to give a cleaner appearance for print outs?
-
"% Allocation", "Assigned Resource", "Task Duration" Impact to Task's End date??
I would appreciate some guidance on a common project scheduling practice in Smartsheet. Typically, resource allocation (% allocation) and assigned resources are defined before building the WBS. Task start and end dates should then be driven by both task duration and the assigned resource’s availability. For example, if…
-
Limit Time-slot selections
I am creating a sign-up form for an event, in which people will select a time slot to attend (1:00, 1:15, 1:30, etc.). There are 12 possible selections, and I can have a maximum of 4 people select each option. It would be wonderful if after the fourth time an option is selected it either disappears, is greyed out, or the…
-
Re assign task midway thru
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
-
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…
-
Quick way to find scheduled send reports from across multiple reports/sheets
Kia ora, Is there a quick way to discover where scheduled send reports, from a report or a sheet, have been set-up, and then modify or delete their occurrence? I have multiple project sheets on the go, and at the close of each I go in and disable all automation workflows, however I don't have capacity (or memory) to check…
-
Bridge: Create Workflow Schedule State Values
I was trying to use the Scheduling: Create Workflow Schedule module in Bridge to set up a 60-minute timer that would alert our team if another workflow didn’t complete within that window. I was struggling with how to pass and access state values between the workflows. After working with a Pro Desk support agent, we figured…
-
Resource levelling / capacity-driven scheduling
I've had a number of discussions with clients about the ability to level resources, which is something MS Project has offered forever. In the context of RM, where the capacity view currently just reflects task assignments based on the project schedule logic, some clients would prefer to have their resource capacity…
-
Resource Management Schedule view by department
Hello, Is it possible to get projects grouped by department like in the attached picture? I don't see where there's an option to sort by department, and from my understanding using tags for projects (i.e. creating a "Marketing Department" tag and attaching to appropriate projects) doesn't consolidate them as nicely. For…
-
Can Smartsheet Resource Management Schedule be grouped by Department?
In Resource Management schedule, I would like to be able to see all of the projects each department is committed to in a timeline view. For example, I'd like to see Marketing department (projects A, B, C), IT department (projects, A, C, D), etc. It seems like I can only view by people with varying filters. Does anyone know…
-
Merged: Develop the ability to add CONSTRAINT TYPES to project schedules
This discussion has been merged.
-
Updating Project Schedule dates using Excel Spreadsheet (duration causing issues)
I have a schedule that is thousands of lines long. I have a .xlsx file with my unique identifier (Schedule Item #) in one column, activity description, start, and end dates in my file. My Smartsheet settings are set to automatically calculate the duration of the duration in a separate column based on the start/end dates.…
-
See time and not percentage in Schedule Tab
Hello, Currently, in the Schedule tab in RM, we are seeing by default the allocation percentages of the resource. Is there a way to see as default the time per day and not the percentage? Thank you in advance, Marco
-
Merged: Scheduling activation or deactivation of forms
This discussion has been merged.
-
Maximum Concurrent Tasks
Working with a multi-family developer building multiple apartment buildings on the same project. Trying to get in front of bottlenecks in the schedule where we're expecting multiple crews in multiple buildings and end up short staffing or over staffing. For instance, Row 58 the Framer should be starting Task "Wall Framing"…