Have a formula that numbers rows and want it to only count certain rows

Hello,

I want to sort items by priority based on order of the rows in the Smartsheet. So, I want lower numbers (rows towards the top) to be shown as a higher prority.

I am using the formula:

=MATCH([Task Name]@row, [Task Name]:[Task Name], 0)

However, I also want to only include certain rows. In particular, I want to only count rows where the column [Type] is equal to "Measure".

I tried this:

=MATCH([Task Name]@row, Type@row = "Measure", [Task Name]:[Task Name], 0)

But that does not work. Any ideas? Thank you in advance!

Find more posts tagged with

Formulas

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @Corey McCarren

You can use the COLLECT function to narrow down the MATCH range.😀

As the range has fewer values than the [Task Name] or Match search values, add IFEEOR to cope with #No MATCH errors.

=IFERROR(MATCH([Task Name]@row, COLLECT([Task Name]:[Task Name], Type:Type, "Measure"), 0), "")

https://app.smartsheet.com/b/publish?EQBCT=3032f774a5344b48a9e67d67623d06b8

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.