-
Import Outlook Calendar into Smartsheet
I was wondering if this is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
-
Calendar Notification/Alert
Hello, We are using this notification for an automated greeting for milestones. Other than custom message, we would like to include an image on our post. However when we are trying to include the column with the image, its not going through. The message is showing the file name of the image (see image below). Adding the…
-
Calendar Recurring Dates
Is there a way to have a specific day and month fill out on a yearly basis. Im saying about date of births and anniversaries. I have to manually enter the current year and it only appears once on the Calendar View. What I would like to happen is enter a date and it will appear on the calendar for the next X number of years.
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…
-
Calendar App multiple sheets
In the key features for Calendar App, it says "Create a Master Calendar - Combine multiple sheets into one master calendar." I can't figure out how to pull from multiple sheets. I currently have 1 sheet that has all our projects with a date range, and then I have a second sheet where holidays, vacation, etc. are entered. I…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Progress charts
Hi, Can some one help me how to build a progress chart using smart sheet? Similar to the one shown below Once level is fine instead of shown 3 levels, would like to show particular day GREEN/RED based on ‘pending requests’ shown in the attached table Any help will be much appreciated Thanks, Basha
-
Gannt View lets you select display label for subtask. I want to do that with calendar view
Is there a way in calendar view to change the label? I love how you can do this in Gannt view and would like to be able to do it in calendar view. I have attached as screenshot of the function I use in Gannt view that would be helpful in the Calendar view.
-
Calendar view using the REPORT feature.
I like using the calendar view when using the report feature. My issue is that when I click on the item in calendar view (from the report), it shows me ALL columns from the source sheet. I would like to see ONLY the columns that are selected from the report builder. I am using the report feature to pare down the amount of…
