I am trying to add a custom column based on the length of the Text column which is column 1 (which contains text and ID numbers). but the code below gives error. is there a way to fix this ?

  #"Added Custom" = Table.AddColumn(#"previous stem", "Custom", each if Text.Length[column1] <> 6 then [column2] else[column3])