-
In office tracker w/ Calendar view
I'm challenged by trying to come up with a simple, efficient and creative method to create a sheet(s) that I can use to track approximately 20 or so colleagues on what days they'll physically be in the office. We're moving to a 3/2 flexible work schedule that allows you to be remote 2 days of the week. I'd like it to be…
-
Calendar App - usage?
My organization is looking to host an organization wide calendar, with sorting, filtering and color-coding features. Would the Calendar app serve that purpose? Can the calendar be linked over/viewable in outlook? Can 2 forms feed into one calendar? Can others view the calendar without logging into smartsheet? Would love…
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Automation
Could you help me ? do you think i did it right? I want to automatically send a reminder mail to the responsible persons on the 60th and 15th days. the trigger should work every day and; it only needs to work on the 60th and 15th days of the contract date. example1: 60 days left until the end of the contract. example2: 15…
-
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…
