Experts ,The name of the uploaded file is eg: MEA-EU.xlsx (Refer the 2nd picture below). I want to extract the name of the file to another 2 column name (GM and DSC).
For example MEA will be under GM Column, while EU will be under DSC column I knew the function of calculated column , but there isn't name of the file to refer(Picture drop down below). So what are the solution? Do I need to use sharepoint designer and if yes how? Or if use calculated how? or there is any other thing that I can do. please help! Thanks in advance