SOLVED

List calculated column works in one tenant but not another

Iron 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 (Iron 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.

1 best response

Accepted Solutions
best response confirmed by Jeffery Hallett (Iron 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.

View solution in original post