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


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.



  • Paul H
    Paul H ✭✭✭✭✭✭
    edited 04/29/22

    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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!