How do I pick a range based on a status to use within Rank

Simon Cowx

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"), "")

MichaelTCA

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

Simon Cowx

Many thanks @MichaelTCA, I've managed to get this working based on the link you provided.