SOLVED

List calculated column works in one tenant but not another

Occasional Contributor

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 -- ex: "21-0143" -- to the number 143.

In a client's 365 tenant I use exactly the same list and formula -- and have tried variations -- but they all result in #Value!

Any ideas?

 

Jeff

I am not a robot!

1 Reply
best response confirmed by Jeffery Hallett (Occasional Contributor)
Solution

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.