-
Calendar View & Booking
Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where they can then invite their own external customers as well as internal guests. In…
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Report and Calendar View
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…
-
Team Calendar on MS Teams
Hi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks, Martha
-
Smartsheet calendar fail to sync with Google Calendar
Hi Community, I'm a smartsheet beginner and hoping I can get some help here. When I follow the steps to publish a smartsheet calendar to Google calendar, the process seems smooth without any trouble. But somehow when I check my google calendar, there is just nothing. The smartsheet calendar didn't appear on the Google…
-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Calendar App Filters
Within the sheet/report, I have a Contact List column that contains multiple contacts per cell. However, when the Contact List column is used as a filter within the Calendar App, these multiple contacts per cell are not broken out into single values. Is there a way to separate values within the Calendar App filter? Or does…