-
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…
-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
How can I export Schedule view?
I am looking to create a custom dashboard that does not seem feasible with the current filtering options available in People or Project view under Schedule. Is there a way to export resource bookings in Schedule?
