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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.