Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?

Simon Godden

I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status.  This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown.  We can also add activity descriptions in the cells too without affecting the status.  My question is: can Smartsheet replicate this?  A dummy data example is below

J. Craig Williams

Yes.

 

Check out the following topics to get you started:

 

1. Project Settings

https://help.smartsheet.com/articles/765755-modifying-project-settings

 

2. Conditional Formatting

https://help.smartsheet.com/articles/516359-conditional-formatting

and

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

 

Hope this helps.

 

Craig