The calculated column is not returning the current log-in user id. RRS feed

  • Question

  • 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.


    Knowledge is power.

    Monday, July 27, 2015 1:40 AM


  • 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.

    Monday, July 27, 2015 2:17 AM