Forum Discussion

Coloray13's avatar
Coloray13
Copper Contributor
Nov 29, 2025

Sequential Numbering Based on Specific Text

Hello, I am having difficulty creating a sequential numbering system in a column, based on specific text (or even better, a checkmark).  I created a table where I often have various rows of data tha...
excel
Formulas and Functions
m_tarler's avatar
m_tarler
Bronze Contributor
Dec 01, 2025

maybe try

=IF([@[SelectCOMP]]="✓",COUNTIF($C$14:C20,"✓"),"")

BTW if you want to use table reference throughout you can try this:

=IF([@[SelectCOMP]]="✓",COUNTIF([[#Headers],[SelectCOMP]]:[@[SelectCOMP]],"✓"),"")