How do I pick a range based on a status to use within Rank
I want to prioritize projects based on a Status. Below you can see a list of projects Ranked in Sore order. If the Priority Category (Status) for a project, I then want to exclude them from the Rank process. In other words how do I only Rank projects with a Status of Active, and not include those that have closed in the future?
Current Formula and screen shot below:
=IF([Priority Category]@row = "Active", IFERROR(RANKEQ([Del Pri Score]@row, [Del Pri Score]$2:[Del Pri Score]$28, 0), "N/A"), "")
Help Article Resources
Check out the Formula Handbook template!