-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Deciding what rows go on my calendar view
I have done this before but can't get it to work this time. In fact, in my current sheet. However, I can't remember how! I have a checkbox column called SHOW IN CALENDAR. I want the check box to determine what shows in the calendar view. Did I create a separate filter with this before? I just want what I want to show in…
-
Calendar App
Hi, I have been using the Calendar App for some time now, but noticed that team members whom have recently got the app have new features that I do not. They are able to custom color code things where my app settings still show just the example tiles and does not give any options to custom color code. Is there a way to…
-
Combine dates from multiple sheets into one calendar
I have 3 sheets, one for marketing, one for sales calls, one for training. How can I combine the dates/items from each sheet onto a master, to create a master calendar that I can then export to ical and put into my outlook?
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Embedding an outlook calendar on a dashboard
Is there anyway to embed an outlook calendar onto a dashboard? I ask because we have been using SS to log hours on a device and to also schedule time on the device. However we have found using SS to schedule isn't working and moving forward will be adding it as a resource to outlook so people can book time on it. We still…
-
VLOOKUP for multiple options influencing Gantt chart
I have a sheet that uses Gantt chart data to show assignments on a calendar. The persons assigned are all in a "Name" column that is a drop down with all the employee names on them. Next to that are start and end date columns that then show a bar range in calendar view. The employee's name will only appear in the bar in…
-
Time off on a per resource level
Hi everyone Is it possible to set the time off (holiday, edit) at the resource level and have it reflected in the project plan? Thanks, in advance, for any guidance. Lloyd
-
Smartsheet Calendar
Hi, I'm trying to create a calendar in smartsheet that can show five different singular milestone dates for multiple projects so that the calendar reflects milestone type and project name for each. To give background, the dates will more than likely flow in order, but I do not want to show a range. Does anyone have any…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"