The reason why its not working is because real columns wouldn't update the values already synced before creating the formula unlike virtual columns, this is why i suggested you to creat a temporary action to update the previous records
The reason why its not working is because real columns wouldn't update the values already synced before creating the formula unlike virtual columns, this is why i suggested you to creat a temporary action to update the previous records