Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Conditional Formatting Gantt Bars & Other Columns
Currently, if conditional formatting is applied to Gantt bars, the format must be applied to the "entire row".
I would like the ability to apply conditional formatting to the Gantt bars and additional formatting to individual columns.
Example:
- format Gantt bars red, yellow, and green for large, medium, and small impact
- format start and end dates grey if they are in the past
Best Answer
-
If you do not adjust any other formatting in the rule used to format the Gantt bar, it should not apply formatting to anything other than the Gantt bar. If it still is, try rearranging your rules so that the rule affecting the columns is above the rule that affects the Gantt bar (also assumes you didn't adjust Gantt bar formatting in the rule that affects the columns).
Answers
-
You can do this with two separate rules since you have two separate rules you want to format.
-
@Paul Newcome. Thanks for the reply. I tried 2 separate rules, but to apply formatting to the gantt bar, the "entire row" needs to be selected. That seems to be over-riding my second rule when applying formatting to a column.
Am I missing something?
-
If you do not adjust any other formatting in the rule used to format the Gantt bar, it should not apply formatting to anything other than the Gantt bar. If it still is, try rearranging your rules so that the rule affecting the columns is above the rule that affects the Gantt bar (also assumes you didn't adjust Gantt bar formatting in the rule that affects the columns).
-
@Paul Newcome. Rearranging the rules worked! I put the date rules above the gantt bar rules and they are all working now. Thanks for your help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a r…
- Can I and how do I set conditional formatting for a Finish Date font to be red if the date is in the past and % Complete is not 100. Is there a way to set multiple conditions for Conditional formattin…
- Hi Smartsheet Community, I have a question regarding Gantt charts in Smartsheet. Currently, my Gantt chart displays a single bar for each project, representing the overall project start and end dates.…
