Hi all - I have created a calendar in my Google account using the URL from the 'Publish to Calendar' function on my Smartsheet. However when I update my Smartsheet and save, it does not automatically update in the Google Calendar I have created. I've refreshed the calendar a few times but the new additions / updates to my…
Is there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)?…
I have a report that pulls data from several sheets. I would like to sync that report to Outlook. Is that possible? I have successfully synced a sheet, but it hasn't worked for a report. If I publish the report I don't see an option to publish a calendar. The only link that is generated is a read-only full version of the…
Hi - I'm trying to add a "Team Vacation Planner" to a Dashboard with a "Calendar" view vs a "Grid" view. No matter what I do, I still get the report in the "Grid" view. Any ideas?? Thanks in advance.
I am using a 12-month calendar template. I have content in one row for May, but need to move it to June. I know I can copy and past but this leaves behind the comments, files, and proofs. I have tried sorting in various ways and it does not seem to work. Do I have to change the formula? Or is there some kind of a way where…
I have 4 columns with Payment and 4 with date I want to associate these payments on a calendar. Like this is going to be my format.
Hey smartsheet community, I have a question regarding the calendar view or maybe calendar app: Is there a possibility to show more than just one date or range. I know the following setting but I want to display more than just the "Transition to BU Date". Is there a chance to do that and in the best case to combine it with…
Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view. I have set up color codes to help determine which is which but now I can't figure out how to get them all to display, looks like…
Hello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I enter the end date of the contract and the notice period on a daily basis. 2- The…
Is there a way to conditionally format different colours to a calendar based on the cells in the corresponding grid? i.e. Department?
