-
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…
-
Change first day of week to MONDAY, instead of SUNDAY
in the German speaking part of Europe, a calendar is usually shown with MONDAY being the first day, and both Weekend days SAT and SUN at the end of the calendar. This should be something that is user specific. So where in the user setting can either the admin or the user himself change the first day of the week from SUN to…
-
Displaying range of dates on a Dashboard
Hi Smartsheet Community, My team currently utilizes a report with multiple sheets to track the due dates of projects. We currently use the Calendar app to display this info - but I'm looking to build an additional dashboard for my team that will utilize this report to display the upcoming due dates in a two-week window.…
