List calculated column works in one tenant but not another

[Jeffery Hallett]

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!

[#2 · Accepted 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.