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

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!