-
Summary Sheet/Report/Cards/?
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
-
How do I create a filter to show Today?
I would like to create a filter that would only show what I have on the Calendar view for today. I'm sure the same filter would work for a Grid View as well. I have one column that has a start date and one column has an end date. For Example: Start Date is 2/10/23 and End date is 2/13/23. If today is 2/11 how do I get it…
-
Reports-Calendar View- Tasks from various sheets intermingled, how to fix?
Hello, I created a report to pull various training calendars into a master report. I have New Hire classes vs Cross Training classes color coded from Conditional Formatting. When I look at the Calendar View of the Report, notice how some of the blue colored tasks are falling under the green colored tasks. How can I keep…
-
Calendar View - Adding Descriptions and Details
Hello, Is there a way to change the view of the calendar entries to include the details in that card? Example: Can the calendar entry in green say "Stephanie Admin" (listed in the activity) instead of only the employee name?
-
Non-work Weekends For Only Some Rows
Hi Smartsheet-ers, I'm looking to organize a project sheet that has some task rows that work can happen on weekends, and some task rows that the work will not happen on the weekends. We work with two staffing schedules. A portion of the staff working on the project work on weekends, while the others do not. Does anyone…
-
I want task duration to ignore non-working days
As part of my project I am ordering parts with multi-week lead times. I have 3 weeks upcoming that our business will be shut down but that will not affect my vendor's timeline. Can I remove a specific "task" from the project calendar and abide by a standard workweek calendar?
-
Google Calendar - not pulling start date
Hi I have published my smartsheet calendar view to google calendar however it's not pulling my start dates. What should appear to be happening over 1 week is only showing 1 day (end date) Is there a way to pull the start date into google calendar? Thanks!
-
Having calendar view pull from today's date
Created a report to reflect the calendar view of a sheet and the oldest date is being shown instead of today's date. How can I make the today date be the default? I added the following formula into the sheet but isn't working: =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
-
How to integrate Smartsheet into Google Calendar? How to import Excel info into existing Smartsheet?
Our Construction Company is wanting to have a Smartsheet to keep track of data for our weekly schedules. How do I get our schedule to automatically appear in a Google Calendar? As of right now, nothing is even showing up in our Smartsheet Calendar, so I don't know if it is a problem with the wrong column being made primary…
-
Integrate with Outlook with Dates and Times and Assignee Information
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…
