#1
|
|||
|
|||
Working out RAG status based on 3 columns
Trying to summarise the RAG status in one field but unsure how I do that
Column D needs to make sure it groups Column A and then column B and then assign the lowest RAG from column C For example, For Workstream 1, 'Pilot' appears twice in column B with the lowest RAG status of Red. So Column D automatically needs to assign Red to Workstream 1, pilot sub workstream. If it is easier then RAG status could be assigned a number too. For example: Red becomes 1, Amber = 2, Green = 3, Complete = 4 etc Table with dummy data below. Grateful for any assistance on this, please. |
#2
|
||||
|
||||
What does "RAG" mean please?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
|
#4
|
|||
|
|||
I had to look it up. It stands for Red-Amber-Green, the traffic-light color coding system that is used in a lot of planning and CRM setups. Red generally meaning it's a hot potato or high priority, etc.
|
Tags |
rag, rag rating, rag status |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to automate Roster file refreshes based on a status value | Tphil413 | Excel Programming | 4 | 08-02-2019 07:43 AM |
Show/Delete paragraph based on checkbox status | mahaabub | Word VBA | 1 | 05-13-2019 05:33 PM |
Late status based on end date | gerhardstru | Project | 0 | 08-03-2018 01:09 AM |
Hide/Show text based upon check box status | nathan.gray@emerson.com | Word VBA | 5 | 12-08-2017 01:08 PM |
Checking ref # status based on sheet2 ref #. | aligahk06 | Excel | 1 | 04-26-2010 11:22 PM |