-
Displaying multiple "dates" in calendar view from same row
Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view. I have set up color codes to help determine which is which but now I can't figure out how to get them all to display, looks like…
-
how can i sync dates in a column with formula?
Hello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I enter the end date of the contract and the notice period on a daily basis. 2- The…
-
Is there a way to conditionally format different colours to a calendar?
Is there a way to conditionally format different colours to a calendar based on the cells in the corresponding grid? i.e. Department?
-
How do you add a sheet in calendar view to a dashboard?
-
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…
