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
Dec 30, 2019 02:40 AM
Hello,
Sorry for the novice question but i was wondering on how to take the first four numbers from a field of numbers itself. I did try the LEFT formula but it doesnt seem to work for me.
Now, there is a field called Ticket with a string of about 10 numbers with the first four numbers being the year. I want to take those four numbers from that field and put them in another field.
Dec 30, 2019 06:56 AM
Hey,
In order to do that, you first need to ensure your field is defined as text (A) and not a number (#). That should be all.
Cheers
Fred