-
Date-time format
When are you developed the possibility to have date-time format ?
-
Increment dates for new year
I have an existing sheet which contains a schedule of annually recurring tasks. I saved a copy to create the new year's sheet and now need to update the dates. Is there an automated way to do this?
-
Downloading, not sync'ing Google Calendar into SS
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…
-
Highlight a Completion Date on the Calendar
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…
-
Calendar View Conditional Formatting
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.
-
Need a workaround so Parent Rows stay children rows when sorting
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.…
-
Gantt timeline
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
-
Finish to Start dependency
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…
-
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…
