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

Corey McCarren

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!

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