Gantt chart, how to color weekends grey?

Joel Ineichen

Hi all

 

Simple question: I have a Gantt chart, but all is white. To make it easier to read, I want to color weekends grey. How can I do this?

 

Thanks

 

Tony Davidson - SmartSheet Certified User 2016

This link below should be helpful..

 

http://help.smartsheet.com/articles/516441-changing-the-color-of-gantt-calendar-bars

Joel Ineichen

Hi Tony

 

Unfortunatley no, I don't want to color the Gantt bar itslef, I want to color the Saturday and Sunday column, so the grid behind the bars. 

I saw that when I declare Sat and Sun as non-working days, it does color them that way, but I do not want to declare Sat and Sun as non-working days.

 

Regards

 

Jeremy Myers

Yes, that would be a welcome addition!

Joel Ineichen

@Jeremy

So you say, what I am looking for does not exist with smartsheet?

Tony Davidson - SmartSheet Certified User 2016

Hi Joel..a quick email to support@smartsheet.com should get your answer..I'm not positive on that one..

John Sauber

Make a checkbox column with this formula in all the rows:

 

=OR(WEEKDAY(DateColumn1) = 1, WEEKDAY(DateColumn1) = 7)

 

Conditionally format against that checkbox and you're done.

Joel Ineichen

@John

Thanks for your reply. Unfortunately I don't understand your proposal as I am new to smartsheet. Can you tell me in more detail what I shoudl do where exactly?

John Sauber

Check it out here.

 

https://app.smartsheet.com/b/publish?EQBCT=1262fc277a7d4d86bdc51ab1ac21dc3e

J. Craig Williams

Oddly, when the Project Settings are displayed, the weekends are greyed, so the functionality is there.

 

 

but it goes away when the dialog is closed.

 

I thought it used to show them that way, but I may be misremembering.

 

Craig

Heidi Nyline

Did this ever get explained or sorted? I would love this feature to be enabled.