SOLVED

Auto RAG in Timeline Bar

%3CLINGO-SUB%20id%3D%22lingo-sub-3469662%22%20slang%3D%22en-US%22%3EAuto%20RAG%20in%20Timeline%20Bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3469662%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20have%20a%20custom%20column%2C%20in%20which%20I%20have%20traffic%20lights%20(Red%2C%20Amber%2C%20Green)%20displayed%20depending%20on%20the%20number%20it%20has.%20The%20task%20is%20added%20to%20a%20timeline%20view%20(custom%20view%2C%20created%20based%20on%20timeline%20screen).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BIs%20it%20possible%20to%20automatically%20color%20the%20bar%20in%20timeline%20view%20as%20per%20the%20RAG%20for%20the%20task%20%3F%20As%20of%20now%2C%20I%20manually%20select%20each%20bar%20(%26amp%3B%20there%20are%20about%20100%20of%20them%20%3A(%3C%2Fimg%3E%20)%20and%20change%26nbsp%3B%20the%20color%20to%20match%20the%20task%20RAG%2C%20but%20was%20hoping%20if%20there%20could%20be%20a%20more%20efficient%20way.%20May%20be%20a%20macro%20or%20a%20hack%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3469934%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20RAG%20in%20Timeline%20Bar%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3469934%22%20slang%3D%22en-US%22%3E%3CP%3ENKumar2010%2C%3CBR%20%2F%3ESorry%20but%20Project%20does%20not%20%22expose%22%20most%20elements%20of%20the%20Timeline%20view.%20If%20a%20task%20on%20the%20timeline%20is%20manually%20selected%20there%20is%20VBA%20method%20that%20will%20select%20that%20task%20in%20the%20Gantt%20Chart%20view%20but%20there%20is%20no%20reverse%20method%20(i.e.%20selecting%20a%20task%20in%20the%20Timeline%20based%20on%20a%20selected%20task%20in%20the%20Gantt%20Chart%20view).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20what%20yo%20wanted%20to%20hear%2C%20but%20that's%20the%20limitation.%3CBR%20%2F%3E%3CBR%20%2F%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

  I have a custom column, in which I have traffic lights (Red, Amber, Green) displayed depending on the number it has. The task is added to a timeline view (custom view, created based on timeline screen). 

   Is it possible to automatically color the bar in timeline view as per the RAG for the task ? As of now, I manually select each bar (& there are about 100 of them :( ) and change  the color to match the task RAG, but was hoping if there could be a more efficient way. May be a macro or a hack ?

 

Any thoughts ? 

1 Reply
best response confirmed by Dale Howard (MVP)
Solution

NKumar2010,
Sorry but Project does not "expose" most elements of the Timeline view. If a task on the timeline is manually selected there is VBA method that will select that task in the Gantt Chart view but there is no reverse method (i.e. selecting a task in the Timeline based on a selected task in the Gantt Chart view).

 

Not what yo wanted to hear, but that's the limitation.

John