Forum Discussion

y2kardell's avatar
y2kardell
Copper Contributor
Dec 11, 2021
Solved

Calculated Field for Sharepoint Column

Hi I have a issue I am trying to find a solution to, here's the scenario.

I have column in my Sharepoint list called 'Tracking #' in List A and another called Tracking (Last 4) in List B. When the user inputs the tracking number (ex: 12345678) I would like to take the last 4 of the number that the user inputs (in this example 5678) and have it copy over to List B. 

My issue is not copying from A to B, but whether what the correct calculated field function would be for Tracking (Last 4) to make this happen. Can anyone assist with this request?

Thanks for the help,

y2kardell

 

SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Dec 13, 2021

    y2kardell Use below formula in calculated column: 

     

    =RIGHT([Tracking #],4)

     

     Output:

    Documentation: Right Function 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Dec 13, 2021

    y2kardell Use below formula in calculated column: 

     

    =RIGHT([Tracking #],4)

     

     Output:

    Documentation: Right Function 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources