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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!