Mar 22 2021 09:57 AM - edited Mar 22 2021 09:58 AM
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!
Mar 22 2021 03:47 PM
SolutionI 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.
Mar 22 2021 03:47 PM
SolutionI 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.