-
Week over Week Variance?
Hey Smartsheet Friends! We are operating in a Construction Environment where we are tracking an entire build schedule, start to finish. At the beginning of the project, we set the baseline to track the original start and original finish date. This allows us to understand the length of time that we deviated from schedule…
-
Slot scheduling conflict within a date range
Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Start Date, End Date. I would like the Conflict cell to be automatically flagged if any one or more slots have already been…
-
Index/Collect returning #INCORRECT ARGUMENT SET
Hello, Community! I'm trying to bring in the value of the Available? column from the Availability sheet into the same named column on the Schedule sheet where: (1) Rescheduled on Schedule sheet matches Team Member on Availability sheet and (2) Start on Schedule sheet matches Date on Availability Sheet. My current syntax…
-
Combining IF/AND/OR to return a value when multiple criteria are met
Hi Everyone, I am trying to filter out tasks on my Gantt chart occurring over the next three weeks. We found a good combination of filters that works for reports, however I want to be able to create a filter like this for the sheet so that the tasks can easily be edited in real time. Sheets do not allow for the hierarchies…
-
Report on tasks for the next 3 weeks
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…
-
Legacy Resource Management & Multiple Contacts
Hi Community, I am working on a project that has several sheets. The sheets have multiple tech's assigned to each project on the same row. Does Legacy Resource Management not work if the contact column is shared? I'm missing quite a number of my resources whom are all part of my account. Thank You!
