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:


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?



I am not a robot!

1 Reply
best response confirmed by Jeffery Hallett (Contributor)

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.



Click here to unsubscribe.