is there a way to generate incremental number to name that is listed more than once

I have a store number; each store has a monthly store visit date. I am looking to use the store number and add the number to show how many previous visits there were before.

I have a formula to add an incremental number, but it did not represent the number for the specific store's visit.

Is there a formula that can get me to the Store Visit ID?

Hope that makes sense.

Thanks

Tags:

Answers

  • MarkCep
    MarkCep ✭✭✭✭

    I figured out -

    =COUNTIFS([Store Visit Date]:[Store Visit Date], <[Store Visit Date]@row, [Store Number]:[Store Number], =[Store Number]@row)

    then in the Store Number ID column - using that value, and joined it to the Store Number

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!