Help

Writing a formular on taking first four numbers of another field

Topic Labels: Formulas
1072 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ahmed_Iyadh
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
FredK_Trashmail
5 - Automation Enthusiast
5 - Automation Enthusiast

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