Sharepoint List calculated value basic formula doesn't work

%3CLINGO-SUB%20id%3D%22lingo-sub-1595919%22%20slang%3D%22en-US%22%3ESharepoint%20List%20calculated%20value%20basic%20formula%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595919%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20we%20are%20using%20Sharepoint%20online%20modern%20framework.%3CBR%20%2F%3EWe%20are%20trying%20to%20do%20a%20simple%20extraction%20of%20a%20string%20value%20in%20a%20column%20to%20extract%20the%20last%204%20digits%20into%20another%20column.%3CBR%20%2F%3EScenario%3A%20COLUMN1%20has%20a%20string%20value%20of%20%22ROOM%20AT%20144%22.%3CBR%20%2F%3EWe%20then%20create%20another%20column%20named%20COLUMN2%20with%20a%20calculated%20value%20based%20on%20another%20column%20and%20enter%20the%20basic%20formula%20of%20%3DRIGHT(%5BCOLUMN1%5D%2C3)%20and%20get%20an%20ID%20CORROLATION%20ERROR.%3CBR%20%2F%3EBut%20if%20we%20enter%20just%20the%26nbsp%3B%3DRIGHT(%5BCOLUMN1%5D)%20we%20get%20the%20value%20of%20%224%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1595919%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hi, we are using Sharepoint online modern framework.
We are trying to do a simple extraction of a string value in a column to extract the last 4 digits into another column.
Scenario: COLUMN1 has a string value of "ROOM AT 144".
We then create another column named COLUMN2 with a calculated value based on another column and enter the basic formula of =RIGHT([COLUMN1],3) and get an ID CORROLATION ERROR.
But if we enter just the =RIGHT([COLUMN1]) we get the value of "4"

0 Replies