Is there a way to apply the conditional color formatting to the Gantt View bar itself?
In the conditional formatting dialog you have the option of choosing the color of the gantt task bar.
You can find more info here:
Conditional Formatting | Smartsheet Learning Center
I should of been more specific, is there any way to apply the conditional formatting to the Gantt bar without setting it for the 'entire row', it seems that the Task Bar option disappears when I select only a few cells that I want the formatting to apply to.
I hope you're well and safe!
Unfortunately, it's not possible now, but it's an excellent idea!
Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.
I hope that helps!
Be safe and have a fantastic weekend!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
You're correct, you'll need to select "Entire Row" for the Task Bar to appear because it is not limited to specific columns. If you have other formatting rules based on the same conditions that you want to apply to only certain columns, you'll want to create two rules with the same conditions but different outputs.
Here's more information around Changing the Color of Task Bars.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.