PTO Calendar

Hello!

I have created a centralized PTO tracker that collects information about their PTO, including reason. I want to be able to create a calendar for each of our teams. The best way to do this seems to be via a report, but the viewer has to have access to the base sheet in order to view it. Because the base sheet contains private information, I can't share the sheet with them.

Are there any workarounds? I've tried creating a helper sheet to move rows over and collect only columns I want in a new sheet, but splitting them out by manager has been a problem. I started creating unique number sequencing with a prefix unique to each team, but if I sort it will throw the formula off not making it viable.

Thanks in advance!

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

Have to tried the Calendar App (if you do have that available for your Smartsheet account)

Amy Meekings

I do, but when I try to share it with someone who doesn't have a license (not everyone in our company has a license), they are not able to view it, otherwise it would have been a great solution.

Amy Meekings

Actually, it worked! I just needed to change the sharing permissions, thank you @SK!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.