How do I pick a range based on a status to use within Rank
Hi,
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"), "")
Answers
-
Hello @Simon Cowx
You could use a COLLECT() function to apply multiple criteria.
Here's a discussion that has answered your question. Hope this helps!
https://community.smartsheet.com/discussion/98393/help-with-ranking-based-on-criteria-rankeq-collect
-
Many thanks @MichaelTCA, I've managed to get this working based on the link you provided.
Help Article Resources
Categories
Check out the Formula Handbook template!