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.
Form / Calendar Integrati
Hi, I'm working on developing an induction booking process that allows our team to book site induction through Smartsheets. Firstly, I intend to have a Smartsheet induction register that will include columns such as induction date, who the inductor is, requester, role, company, email address, etc. Any one who would like to…
UTC Date Fix - Response Required
I've not been active on this site over the past 2 weeks or more, simply because I'm becoming increasingly frustrated with the limitations I'm faced with because of bugs, oversights and a lack of fundamental features. Primary for me is a fix to the UTC Server vs Local date issue. I've spent time trying to get around it with…
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…