I have a few people extensively using their Google calendar to keep track of activities: They just create a new calendar entry on their phone for new or unexpected events ("The 1 hour meeting actually lasted 3 hours", "car broke down and I spent 2 hours at garage", "I ended up having lunch with client X"). To eliminate the…
Hello All, I'm looking for a way to highlight a particular date so that it shows in a different color (something like the red shading that already marks holidays). I want it to be visible on all rows so that I don't need to scroll to the bottom or top of the schedule to see what the target end date is. Has anyone found a…
I know how to set conditional formatting to the row for the calendar view. However, I want to format more than just the taskbar color. Is there a way for the font, bold, and underline to also transfer to the calendar view? I am attempting to differentiate two tasks by font, etc. with the same task bar color.
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…
Hi! I'm finding the Gantt timeline zoom options quite restrictive/extreme. Does anyone know whether there is way to either: - Zoom the timeline more variable than the standard extreme settings - Show 12-months' worth of timeline Thank you! Steve
I have a question that I am embarrassed to ask. I thought that I would know the answer with no doubt . If you build a task that is dependent on the completion of a previous task with a Finish to Start relationship (very standard) and the previous task ends on April 9th (a Monday) shouldn't the next task (the dependent…
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…
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…
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…
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.
