How can I display statuses of data?

1. All the “Y” values need to be converted into numbers in the “summary” sheet. So for example Keyword building team creates events=1, NO Level 1 examples=2, Ready for Business Review=3, Business Review=4, Legal Review=5, and Production=6

*this requirement can be skipped if it gets too complicated, but the events will still denote in the same number so for G3 is level 1, H3 is level 2 and so on.

2. In the Ranking Summary Sheet I have added a “Status” Column that will denote what status each event is in. If one of the events is equal to a 6 then it will say RELEASE. If it is not a 6, then it will denote what number or status it is in from the “Summary” sheet.


So for example,

Event Status
Cookie RELEASE
Bicycle 3
Toy 2
Cheeseburger 1