I’m new on airtable and would love some help creating an IF formula.
Context: I’m trying to create a unique vendor code for SKUs. Ive added an autogenerate number field called “Vendor Number” and added a “vendor code” field where I would like to create the IF formula. I want to to add “00” at the beginning of the vendor number if the vendor number is less than 10, add “0” if the vendor number is less than 100 and show only the “vendor number” if it is greater than 100.
Vendor Number: 7
Vendor Code: 007
Vendor Number: 19
Vendor Code: 019
Vendor Number: 122
Vendor Code: 122
Any help would be greatly appreciated!