Populate new column based on values of another column
I'd like to do something like an Excel VLOOKUP ---- where I'd like to populate an empty new column (New_Status) with values from the original column (STATUS) --- but some of the values need to be translated.... many of the original status entries do not state explicitly that the item is 'Open' but for my purposes they are open.... so I'd like a column that consolidates all the text that mean...