-
IF AND OR Statements
Hello! The sheet on the back end has multiple checkmarks to select what role the event is for. I am needing to create a formula that will give a Academy name based off of which checkmarks are checked. The column for academy name is a dropdown column. i.e. If support office is checked support office academy is put in the…
-
Calendar App: display checked items in filter
I want to set up a filter to show only the items that are checked (column type: checkbox - star). I would assume the logic is to select "is not blank" but this doesn't work — it still shows every row, even the ones with blank checkboxes. Is there a different option I could select and what should I put in the "compared…
-
Calendar App Data Grouping Order
Calendar App gurus, please help. I've got a Project Plan sheet that I've got five groups or buckets. I created a Report that only shows the top-level records/rows (so five rows). I have created a Calendar App from that report that is sorted the way I want it to display, but in the Calendar App, it has things out of…
-
Calendar App: What is the difference between "Ignore Weekends" "Hide Weekends" and "Show All"
In my testing: Show All: Ignore Weekends: Hide Weekends: One of these things is not like the others, and that makes sense. But Ignore and Show All seem to mean the same thing. Why have two settings? Very confusing in the wizard.
-
Is Hide Weekends supposed to ONLY work with Monday as the week start date?
In the Calendar App, Daily View, if I select "Hide Weekends", but have "Sunday" as the start of the week, Friday and Saturday are hidden, rather than Sunday and Saturday. This seems very very odd to me.
-
Campaign Calendar
Hi, I am trying to set up a campaign calendar in smartsheet. But when Calendar tries to pull information from the spreadsheet, this is how it looks(attached). It cuts in between the rows. I created a ticket, but smartsheet closed it without resolving it. Can anyone help?
-
Where you do you associate the correct Google account with Google Calendar sync?
For some reason, the calendar is sending to a Google account that it not the same as the address associated with my Smartsheet login. How do I change that?
-
Embed Calendar App in Sharepoint
I'd like to start by saying I have other Smartsheet calendars that are successfully embedded on a SharePoint site. However, I recently created a new calendar and for whatever reason I cannot get this one to show up on SharePoint. I've created a dashboard and pointed the calendar app to the dashboard, then published the…
-
Add Calendar View links to Collections
I am unable to add links to Collections for Calendars in Smartsheet Calendar module (not calendar view in sheets). I would like calendars to either be selectable as one of the Smartsheet resources, or embeddable by link.
-
Calendar App - colour & order consistency
I have a calendar in the calendar app with 2 column groups and multiple tiles. When i set and use filters the order of the columns flips randomly (the view does not remain constant). e.g. column 1 will show group A, Group B, Group C, but if i change the filter it will show C, B, A, or B, A, C (seemingly very random) - even…
