-
How to move an item in Calendar view and ensure it also updates the finish date in Grid view?
Hi Everyone, I'm working on a social media calendar. I have these columns: 1) Copy, 2) Start Date and 3) Finish Date. When I drag and move the post in Calendar view, it updates the Start date to the new day, but the finish date stays the same. What function can I use for this? Example: I have Post #1 with a start date of…
-
"pending for approval" when transfering ownership of a smartsheet calendar
i tried to transfer calednar ownership to another person. After set this guy as Admin of every sheet and report this calendar linked and then click "transfer, it showed as the red font in the pic. But neither me or this guy can see the approval process and we had no idea who should approve it. does anyone have any idea…
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
fixed durration vs. fixed start/end dates (deadlines) with gantt chart
I'm trying to develop a template for scheduling the 30 to 60 sub tasks in each of the many year long projects I'm managing. Im hoping to use a dashboard to tack all the projects at once. but for the template id like to set up an easily adjusted Gantt calendar. There are dates that are subject to fixed dates like quarterly…
-
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…
