Sharepoint List calculated value basic formula doesn't work

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"