Forum Discussion
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 -- 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!
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.
1 Reply
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.