-
Published calendar on Outlook - wrong dates
Hi, everyone. I am having an issue with dates when publishing a sheet to iCal. The sheet has several date columns, and it has the following settings (images below): "warranty expiration" as the sole date for the calendar calendar enabled on publication I added the published calendar to Outlook (O365) and the dates are not…
-
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…
-
Countif the Year 2021 on a Column Returns #invalid data type or zero.
https://app.smartsheet.com/sheets/xXvWq9JrWMjRXGHv7jcV4Q4GF45wJWc4C32GcHw1
-
I can't edit a filter on my calendar view - there is no pencil icon - any help please?
Hi there - a colleague shared a calendar with me, and I want to edit a filter, or even add a filter. But there is no pencil icon when I go to the filter, or when I hover over it. Any help appreciated.
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
Calendar App - Multi-Select Field with Filter
Hello all, I'm looking for a way to be able to utilize a filter on multi-select so that it incorporates the relevant datapoints. However when we do the grouping, it effectively creates grouping by groups and effectively miscategorizes the information. Example: We are using the calendar app for a launch calendar that we…
-
Best practices/overbooking for Smartsheet calendar app?
My company (Bath remodeling company) has our install calendar currently on excel and we do about 22 jobs a day. We are planning to migrate our calendar to Smartsheet calendar app and we are having issues finding a way to provide block outs for some Installers when they request off or how to prevent overbooking. I created a…
-
Using the ,21 (ISO) option when determining WEEKNUMBER - Sheet displays ok, Report doesn't
Hi, When using this formula to return a week number =IF([Date completed]@row = "", "", WEEKNUMBER([Date completed]@row, 21)) the correct week number value displays accurately in the sheet which is good. However, the Report fails to display the column value and displays #INCORRECT ARGUMENT SET Removing the ,21 parameter and…
-
Is there a way to have appointment times appear in the calendar view?
I have searched the help and forums and did not find a simple solution but it sounds like it is an important feature to many users so there must be a solution. Thank You for any advice.
-
Calendar View
Hello, I would like to have my grid locked in calendar view. As it is right now, users would have to select that view for themselves. Also, how can I have a report that is in calendar view display as such in a dashboard? TIA. -BR
