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
Check out the Formula Handbook template!