I created a formula that summarizes my status column’s and their status’s (in one column). The problem I seem to figure out is when a status column doesn’t have a status, it creates the word “empty” in my summarized column. Is there a way to tell it, that if, that is status is blank, it doesn’t put anything in the summarized column. See my example below. There are 3 other columns to the left of the column called “ED” that have status’s.
P.S. I’m sure there’s an easier formula, I’m new at this extensive formula stuff! LOL