-
Highlighting/Colouring Sundays in Gantt Chart
Hello, I want to colour all Sunday columns in a different colour than Monday to Saturday in my Gantt Chart Just like in the following Image; there are the Saturdays and Sundays with a grey background. EDIT: Okay, I got the issue. I also highlighted the rows of the main-tasks and its child-tasks in several colours (Task 1 +…
-
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…