-
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…
-
Bookend a scheduler task with two predecessors & variable number of days
My smartsheet scheduler task will float between two predecessors… meaning it will start at the same time as one task (i.e. 10SS) and finish in coordination with another predecessor (i.e. 12FF). The number of days will technically be variable and change as the predecessors change. Smartsheet does not seem to allow this, but…
-
Merged: Gantt View: show milestones in the parent summary when collapsed
This discussion has been merged.
-
Merged: Baseline Date Functionality
This discussion has been merged.
-
Scheduling automatic reminders for Proof reviewers
Here is a way to create reminders for Proof reviewers. This solution will: Send a reminder 5 days after the initial invite, if no one has responded to a Proof review request. Send a reminder 5 days after the last reminder, if no one has responded to a Proof review. Reset when a new Proof version is created. Some useful…
