-
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
-
Calendar App security enhancement
We are working with the Calendar App and would like to be able to apply security based on groups to the same CalendarApp calendar, similar to row-level security. For instance, we want to use the same dataset and Calendar App (link, but have a public view and manager view based on filters.
-
Calendar app wont show hyperlinks from sheet
Hi Sheet Hyperlink not carried through into calendar app unable to access is this normal behaviour. Thanks
-
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!
