Simplifying text to another column
Hello! I think I need some sort of IF/OR/AND/THEN formula for what I'm working on. I am working in a sheet that has a status column with 8 different text values. My team wants to simplify the look of this in our external dashboard, so are creating a new column that changes the 8 distinct text values into 4 different distinct text values. I've played around with some IF/THEN formulas to get just one value "New" to populate to no success. I am also wondering if you could clear up if you can reference the same column multiple times in a formula. I have attached a photo that lays out the values I have and want to simplify to below.
Help Article Resources
Check out the Formula Handbook template!