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 is not mandatory, requirement 2 is most important.





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.

Attached Files

sample1.xlsx (380.4 KB, 12 views)

Why do you want "y" when you want a number?
For example in H4 instead of =IF(Details!M8=0,"", "Y") enter =IF(Details!M8=0, "", 2) and the same for the other columns

__________________
Using O365 v2503 - 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