-
VLOOKUP and Conditional Formatting
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its due date no longer works on the VLOOKUP cells Is there something I'm doing wrong? Or is this a limitation of the software? Has…
-
Calculating a date from another date in same row
how do I have the start prepping date calculate off the meeting date automatically in the same row. ie I have a meeting on 1/22/18 and I need to start planning 10 weeks prior and would like it to be automated. The problem is this is a major calendar for over 30 meetings, and all have different lag times for planning. I…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Smartsheet for Outlook and Smartsheet Calendar
Is it possible to add Smartsheet for Outlook to the Outlook Calendar ribbon. I would like to see the Outlook calendar side-by-side with the Outlook Calendar.
-
Calendars
2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO. Can I create just calendars? I created an installation sheet and a service request sheet. Is there anyway to merge the 2 calendars and color code the installation separate from service request. I would like to be able to view 1 calendar to…
-
Error message - publishing SmartSheet calendar to Outlook
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
-
Notification Dates
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
-
Can calendar view default to current month when a sheet is opened?
It seems there'd be a way to do this but I haven't figured it out if there is. I have a calendar that displays important dates from linked cells in another sheet. I set it to default to the calendar view but every time it opens it displays June 2017 even though it's currently April 2018! I'm guessing it's drawing from the…
-
Need for darker lines and dates on printed calendars
I export my shipping dates to a sheet that presents the data as a calendar that is printed and posted for our shipping packers and loaders. This is a great tool for allowing those on the team who are not on the computer to plan their workflow. The default color for the calendar grid as well as month and date labels is…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…