So I have multiple dates, overall project dates and backend development dates which fall inside the overall project dates. Can I have one bad but it be a different color to signify the backend development date within the overall project bar?
You can set up custom colours in your Gantt chart either by manually changing the colour of the bar or by setting a Conditional Formatting rule. See: Change the Color of Task Bars
To manually change the colour, you can right-click on the bar you want to adjust and select Color Settings:
In Conditional Formatting rules, you'll want the rule to be set for the entire row, then change the Task Bar colour portion:
See: Apply Formatting Automatically with Conditional Formatting Rules
Keep in mind that if you're using Hierarchy in your project, you will only be able to change the colour of Child Row tasks. See the Note in the bottom of this Help Article: Parent Rollup Functionality
Parent Rows will always display as a grey bar showing the earliest start and the latest end date of their Child tasks:
If I've misunderstood your question it would be helpful to see screen captures of your sheet set-up, but please block out sensitive data.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.