How do I create an auto numbering system based on a value in another column?

JJMunoz

I have a form connected to my smartsheet. I want a column (this example "Count") to auto number based on what another cell in a specific column has. For example, one column has either 'apple' or 'orange' displayed. I want another column to keep a count each time a row is added from the form, with either apple or orange. Hopefully that makes sense.

TIA

Paul H

I would use a auto system created date for the date column

Formula for the count column

=COUNTIFS(Type:Type, Type@row, Date:Date, <=Date@row)