Seperate Auto Numbering Based on Area Column

I have an auto number column which I know goes from 1-100 etc. I have projects in Locations North, South, East and West. Is there a way I can auto number based on each location so East is sequential, North is sequential, etc. By using the below formula it works fine but I end up with North 15 when it might be the 15th row entry but only the 2nd project in the North.

Hope that makes sense!

="ME_" + REGION@row + "_ALL_24_" + [AUTO NUMBER]


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!