Selective Counter Column

Hello Everyone,

For the purpose of tiered pricing, I am trying to add a column to a sheet that tracks the instance number of a row with a particular property.

For example: I add an row/item, enter 'medium' in the size column, and the formula in question picks up that this is the third 'medium' item in the sheet, counting from the top. It then generates the string 'M3' and does not change the data when another medium is added.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!