-
Setting up access to a Smartsheet Calendar in Outlook
We are migrating our vacation and PTO requests into a Smartsheet. We would like the calendar view that our payroll admin has of all the approved time off to be available for all to see in outlook. I took the webcal link and shared it with several staff members to see if they could access the calendar. It looks like it…
-
Calendar as default view when shared in Teams tab
Is there a way to ensure a Smartsheet imported to Teams always displays in Calendar view? I think I have been able to save this view as the default in Smartsheet itself, but when I open the sheet's tab in Teams it displays as grid view. I signed out of Teams and signed back in to check whether the changes just needed to go…
-
Change the color of Task Bars in Calendar View
I would like to change the color of task bars in calendar view. I understand I can right click and change these one by one, but I would like them to change automatically. I have tried manually changing the rows in Grid View to reflect the color I want the task bars to be in Calendar View with no luck. I also used…
-
Options to show multiple project plan sheets into one view
I currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Has anyone tried to do this before?
-
How to hide columns in callenderview
Inside a Report i can choice what columns i want to show in the grid and gantt view, however if i switch to callenderview and selected a project it shows everything. is there a possiblity its only shows the choisen columns.
-
Where did Publish to iCal go?
Reports in calendar view used to have a Publish to iCal tool easily available. After their last update, it has been replaced with filters and grouping tools. Where do I find the ability to publish calendars now? I can't seem to hunt it down. Publish seems to only have link options not necessarily calendar options. Please…
-
Exporting Calendar View to PDF not working
Hi, I'm trying to export my calendar view from the calendar app to a PDF, however it does not work; it briefly goes blank and returns to the view but does not generate a PDF. Can you help? Also, is there the ability to export this to Excel? Thanks~
-
Adding Months based on Calendar Days not individual days
I am looking for a formula that adds months to a date and keeps the "x" day of the month. Meaning if I am adding 3 months from February 1st, 2021, it would return May 1st, 2021 vs. just adding 90 days to February 1st and returning May 2nd, 2021.
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Can I Highlight and/or use conditional formatting in the Calendar App?
Is conditional formatting, or highlighting, something that can be managed within the Calendar app. e.g. I have specific data from a dropdown column in my sheet displayed for each item on my calendar, but want to highlight the calendar item if it contains a specific dropdown [not using filters, as I still want all data…
