SOLVED

List calculated column works in one tenant but not another

%3CLINGO-SUB%20id%3D%22lingo-sub-2227973%22%20slang%3D%22en-US%22%3EList%20calculated%20column%20works%20in%20one%20tenant%20but%20not%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2227973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Sharepoint%20list%20in%20my%20tenant%20that%20uses%20this%20simple%20formula%20in%20a%20calculated%20column%3A%3C%2FP%3E%3CP%3E%3DRIGHT(ProjectRef%2C4)%2B0%3C%2FP%3E%3CP%3EIt%20works%20perfectly%2C%20converting%20the%20right%20four%20characters%20of%20ProjectRef%20column%20--%20ex%3A%20%2221-0143%22%20--%20to%20the%20number%20143.%3C%2FP%3E%3CP%3EIn%20a%20client's%20tenant%20I%20use%20exactly%20the%20same%20list%20and%20formula%20--%20and%20have%20tried%20variations%20--%20but%20they%20all%20result%20in%20%23Value!%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJeff%3C%2FP%3E%3CP%3E%3CEM%3EI%20am%20not%20a%20robot!%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2227973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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 (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.