-
Calendar functionality
Is there a way to make a recurring event for weekly or monthly easily? I know that I can copy and past into the grid and change the dates but I'd rather use a recurring function. For example, a Saturday market that occurs every Saturday until October. I'd like to add the first date (may 14th) and then set it recurring…
-
Date formula in content calendar template
I'm trying to copy the content calendar template into the rest of the months for this year. It has January filled out but the rest are blank. I'd like to have the week column updated to the correct dates for each week in the month. I can't seem to figure out the formula to correct the issue (you can see below the date is…
-
Can I lock the view of a report in Calendar view?
I have a report that is saved in calendar view and a link is placed on a dashboard. When I open the report either directly or via the dashboard link it opens in calendar view. However when shared collaborators open the report it opens in grid view.
-
Calendar App / Contact Lists
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App? We have a calendar that references an existing Smartsheet - Sheet. The sheet has a contact list column labeled "Assigned". When the this…
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Can't always open calendar details on Smartsheet Calendar app
For some reason, I can't open all of my rows on the Smartsheet calendar app when I click on it for more details. When I click on some, it does nothing. If I click on some others, it will open and I can click back to the row that didn't open and it will open with job details. I narrowed it down to rows that are duplicated…
-
How to set the start date on a given day of week after predecessor completes
If I have a task that can only happen on a Tuesday (e.g. that's when an approval committee meets), and all the predecessors are scheduled to complete the previous Thursday, how do I schedule the task to start on the first Tuesday after the predecessor completes?
-
Updating an Existing Calendar with a New Sheet
Is there a way to sync information from a sheet onto an existing Google Calendar? as opposed to creating a new one? I know that it is possible to create a new Google Calendar from a Sheet, but the issue I have is that it provides a whole new Calendar, and what I want to do is simply use the Sheet to update an already…
-
Use Predecessors for a Shared Start Date and Extended End Date
I am working on a marketing project plan template, and some of our campaigns spend multiple days in market. Tracking the performance of these projects happens for the duration of the project plus the duration of an attribution window. Example: An email campaign launches on 4/1 and runs through 4/7, and any email leads…
-
Calendar View Order
Hopefully an easy question...I'm just getting started using smartsheet. Can someone tell me how calendar view determines the order of items within the calendar - i.e. what is listed on top of a certain date, what's below that and so on. Thank you!
