-
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"
-
Times in calendar view
Hi there, I've read some previous threads from 2015 about this, but wondering if there's been any further progress - we manage multiple events a day and with the calendar view not showing specific times it's difficult to utilise it to its full capacity, particularly as I am trying to also sync it to the larger calendar on…
-
Recurrent Reminder for anniversaries and Birthdays - old dates
Hi there, I set up a spreadsheet with all our employees' details. Now I need to set up recurrent reminders for Date of Births and Anniversaries, but obviously, being old dates they are not considered. Is there any way where this can be done? Thanks
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…