Forum Discussion

MindeaLLC's avatar
MindeaLLC
Iron Contributor
Mar 22, 2021
Solved

List calculated column works in one tenant but not another

I have a Sharepoint list in my 365 tenant that uses this simple formula in a calculated column: =RIGHT(ProjectRef,4)+0 It works perfectly, converting the right four characters of ProjectRef column ...
  • MindeaLLC's avatar
    Mar 22, 2021

    I got it working. I changed the calculation formula the Value(RIGHT(ProjectRef,4)) and it worked. I swear I had tried that already, but apparently this is one of those time when doing the same thing over actually DID yield different results.

     

    Jeff

    Click here to unsubscribe.

Resources