-
Change start date without breaking dependencies
Hello, how can I change the start date without breaking the Predecessors? I want to keep the predecessors and be able to change the start date. i want the assignee to update the start date and at the same time i want to keep the duration for the tasks locked, and automatically delay the next task (dependent). example: lets…
-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
Setting Up Priority Predecessor and Automatic Task Allocation in Smartsheet
I am currently managing a project with approximately 500 tasks, and new tasks are being added every week while others are completed. My tasks are divided into three priority levels and fall into different categories: short-term one-time tasks, medium- or long-term one-time tasks, and recurring tasks (monthly, quarterly, or…
-
Creating Linked Sections of a Schedule
Hi first an introduction to what I am doing. I am a construction manager and I am exploring Smartsheet to up the efficiency. Call it R&D if you will. I wanted to describe what I am looking for without filter , I hope an expert tells me if it is feasible. The function I am looking for is this: I have different parts of the…
-
Populating Multi_contact_List column through Alteryx
I have an Alteryx designer reading in tasks from multiple smartsheet schedules that have a responsibles column with multiple contacts. I want to rewrite those contacts into the one schedule I am writing to, but when the contact is read in, it is converted to TEXT_NUMBER and Alteryx won't let me write to the Multi Contact…
-
Employee Shift Schedule - Daily: Monday Through Saturday
Hello, I need help creating a sort of shift schedule to send out to my employees at the beginning of each week around 6 in the morning, while being able to send a notification to them if they have to go somewhere else. Example of Change of Location notification: If they are at a construction project at 8 in the morning,…
-
Email Report Summary of Tasks at risk - ONLY IF 1 or more tasks are "At Risk"
Hi, I have a colum "at risk" in my sheet, id like to set up a report that sends to summarise all items at risk, i have the report set up this is really simple and no issue. How do i go about restricting the report to only send if 1 or more items meet the criteria, rather than sending a daily blank report and me having to…
-
Meeting Scheduling Management Templates?
Hi Everyone! I hope you're well. I've looked through a gazillion topics and postings and not quite finding what I'm looking for. I'm hoping you can help me with either a template or suggestions (the former is preferred). Basically what I'm needing is a way to track meeting scheduling (not project-related) for scheduling…
-
Projected Labor Needs & Labor Schedule
I have multiple tasks with various durations. At some point, most task's duration overlaps with another. I need to project out on any given day what my total labor needs would be for that day. I have two sheets: Sheet #1 - Labor Schedule Sheet #2 - Projected Labor Needs In the snip-it below (Top Part Clouded) I have…
-
Enhance Predecessor Functionality to Maintain Connectivity and Adjust Dates for Forecasting
Enhance Smartsheet to automatically adjust predecessors without disconnecting when activity dates differ from baseline dates. Currently, predecessors disconnect when activity dates do not match baseline dates. We require a feature that keeps predecessors connected and adjusts dates to project or forecast new dates based on…