Hi,

I created a formula =RIGHT(Me,LEN(Me)-INT(FIND("\",Me))) in the calculated column in a library. The column returns my login name successfully. But the column still holds my login name if the log-in user is other than me. The column is not changing the value based on the log-in user. It always displays my user id irrespective of current user.

Please help me on this.

Hi Manoj,

Calculated column value does not change dynamically, as it will be changed only when you create new item or update the existing item, it is by design like that.

Alternate option is to Client Side Rendering (CSR), where you can change the look and feel of your column.  In your case, you change the column value to the current logged in user by using CSR.  Please refer to the following code samples.

Client-side rendering (JS Link) code samples

CSR code samples #5 (Percent Complete)

Please don't forget to mark it as answered, if your problem resolved or helpful.

• Proposed as answer by Sohel RanaMVP 5 hours 10 minutes ago