Hey all! I have a problem that I hope you can help with. I have a massive amount of data that I need to put into Airtable that I received in the below format. However, I need to put each individual instance into a linked record field in AT, so the 1-5, will need to be 1, 2, 3, 4, 5. The amount of data I have will take me months to manually import one record at a time.
I am hoping to create a formulate that will pull out the hyphenated numbers and return a value of GKM5L1, GKM5L2, GKM5L3... etc for the first line so that I can copy and paste values into AirTable instead of entering manually.
I would really appreciate any help! Thanks!
I don't know if it is helpful, but I tried ChatGPT looking for an answer first, which gave me this response:
Unfortunately, this doesn't work because there is no "Sequence" function.
