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


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!