Applies to
Keep your teams organized with the Smartsheet Calendar App
The Smartsheet Calendar App is a premium add-on that helps you build flexible, customizable, and shareable calendars using your Smartsheet data.
Who can use this?
Plans:
- Smartsheet Advance Package
With the Calendar App, you can:
- Color-code by a primary and secondary category
- Easily export the calendar for email or print
- Sync with existing project data
Sign in to the Smartsheet Calendar App
To access the Calendar App, follow these steps:
- On the left navigation bar, select Launcher.
- Select Calendar.
Another way to access the Calendar App is by visiting this URL: calendar.smartsheet.com.
If you have trouble accessing the app from the Launcher, see Access Premium Apps and Templates with the Launcher.
Once you’re signed in, you get to the Calendar List page. Any calendars that you’ve created or that have been shared with you are displayed on this page. To open a calendar, select its name.
To narrow your search, use the Filter list or type the calendar name in the Search bar.
Create a basic calendar
Create new calendars in the Create New wizard. To start the wizard, select + Add New.
Step 1: Select sheet
- Select the sheet or report that contains the Smartsheet data you want to display.
- Select Next.
Your sheet or report must include at least one date column.
Step 2: Choose a view
To choose the default view for your calendar, select one of the following options:
- Monthly
- Daily
- Weekly
- Multi-Month
- Quarterly
- Day-Month
After your calendar is created, you can switch between these views at any time.
Step 3: Map columns
Map the columns from your sheet to their corresponding fields in the calendar.
- In the Smartsheet Columns section, select which columns contain the data you want to display in the calendar. Fields with a red asterisk are required fields.
If you're using a report as the source of your calendar, use consistent column names across your sheets to ensure that your calendar is clean and easy to read.
Once you choose columns under Data Grouping, you can assign a specific color to each column value in the Custom Category List Order section.
Refine your calendar with advanced features
Do more once you get a basic calendar working. For example, you may want to:
- Add additional columns
- Sort tasks
- Change the date and time display and format calendar tasks
- Change the logo that appears with the calendar
- Show or hide weekends
When you select the Advanced button, you see the following tabs:
- Additional Columns
- Time & Design
- More Options
- Confirm
To proceed, select Next.
Step 4: Add more columns to your calendar
- To add more information to your calendar, use the following sections:
- Additional Columns: Select additional columns to display from your source sheet or report.
- Sort Columns: Sort your tasks based on column data.
- Select Next.
Step 5: Configure how to display dates and time periods
Use the Time & Design tab to configure further how dates and time periods are displayed and the style of calendar tasks.
Step 6: Edit other calendar details
Use the More Options tab to do the following:
- Add a calendar name
- Identify the start day of the week
- Identify the quarter-start month
- Show tasks on weekdays only, hide weekends, or show both weekdays and weekends
- Open and find the web form link
- Set up how the calendar appears to users and what they can do in the calendar.
Allow Attachments
Select this option if you want people to be able to attach files to Calendar App tasks.
Files attached to comments appear with the comment. You won't see the attachments in the Attachments column or on a Calendar App task.
Allow Comments
Select this option so others can comment on tasks within the Calendar App. This setting is enabled by default when you create a new calendar.
When you add comments to a calendar, they're also added to the source sheet or report.
Use the @mention capability in comments to increase the visibility of your calendar entries.
Users must have at least Editor permissions on the source sheet or report to add comments to the calendar. People with Viewer permissions can view comments in a calendar.
Allow New Events
Allow anyone with Editor permissions to the source sheet to add tasks directly to the calendar.
Web Form Link
If the source sheet includes a form, paste the form's link in the Web Form Link field. You can access the form from the Calendar App when you add the web form link to the calendar.
To access the web form from the Calendar App:
- In the upper-left area of the Calendar App, select the dropdown icon.
- Select Open Web Form.
Use a 454 Calendar
To allow 454 Calendar as a display option, select the 454 Calendar checkbox. You can also select Default 454 Calendar if you want this to be the default display option.
In a 454 calendar, the calendar year is divided into months based on this format: 4 weeks – 5 weeks – 4 weeks. The layout of the calendar lines up holidays and ensures that the same number of Saturdays and Sundays appear in comparable months. (The 454 format is commonly used in retail businesses to compare sales between years more accurately).
Step 7: Verify the settings you set up
In the Confirm tab, review and verify the settings you edited. If you need to make changes, select Previous to navigate to the appropriate page and make the necessary adjustments. Once you’re satisfied with the results, select Add or Update.