Prioritize Order of Record Fulfillment
I have a list of records in a worksheet, and would like for each of them to be prioritized 1 through ### (depending upon how many are in the list). Each record needs to have a unique priority, because the order in which the record will be acted upon by an Owner will be determined by where it is ranked in the prioritization. Therefore the number can't be used more than once in the list.
Can this be done? How? Via a formula? Need some guidance.
Help Article Resources
Check out the Formula Handbook template!