-
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?
-
Different Settings in Same Project Sheet
Is it possible, by formula or settings to have within the same project sheet, some tasks & sub-tasks that will need to use a 7-day work week (no weekends, no holidays) and also some tasks (and sub tasks) that will need to utilize the 5-day work week and holidays? To clarify, all of this is in the same sheet for a single…
-
Smartsheet not uploading MS Project schedule accurately
Is there are reason Smartsheet will have different start and end dates, as well as apparently adding removing random tasks?
-
Reservations/Scheduling & WAITLISTING
First time posting, and I'm not sure if I'm doing this correctly, or if this is the right place, please have patience. I have a workspace, with a form, and a sheet (although it's definitely not NEAR as optimal or helpful as it should be), along with a few other sheets/resources (past appointments, contact lists, specific…
-
Appointment Number Generation
I am building a Project Management system to deal with a high flow of scheduling. Currently I have the system built using the auto number column type, however when it came to creating a copy of the row I quickly found that the system will not update that value when it is passed out to a separate grid and cleared of…
