Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF formula that counts up for repeat IDs

Topic Labels: Formulas
326 0
cancel
Showing results for 
Search instead for 
Did you mean: 

I am using a database to keep track of clothing consigners. In my “seller” sheet, my first column is the ID column and I was using LEFT({First Name}, 1) & LEFT({Last Name}, 1) to assign IDs to the sellers.

But now I have an issue where I have 2 sellers with the same initials - so I need the formula to count up as well (IF {ID} IS_SAME, COUNTA, LEFT({First Name}, 1) & LEFT({Last Name}, 1)

So I should be getting this for IDs that continuously counts up - but it’s not working and tells me the text is wrong. HELP!

AB
AB2
CD
CD2
CD3
FE
GH
GH1

0 Replies 0