Project Plan:
Summary for Graph where formuale needs to be written:
Hi Team, Need your help with writing a formulae on the Summary for Graph sheet wherein the Task bars of the column graph can turn to R/Y/G based on what their status is on the Project plan.
The current Graph populated based on the summary for graph sheet is static but needs to be dynamic to auto pick the color and the % progress.
Basically if we can write like a COLLECT formulae or something for Task A wherein it populates the % in that very R/Y/G column associated to its Heath on project plan and populate a blank for others.
Let me know if you need further clarity.
