I have some columns with formulas that pull in information (if information is available).
If the information is not available (filled in), the column puts "#Invalid Value" in that column. Is there a helper row formula I could use to say if the previous column has "#Invalid Value" then enter a space (which I can do) but I can't make it enter the data instead of the space if the previous column has real data. I hope this makes sense ;-O
So on my picture, I want "Secondary Care Site Networks - Do Not Delete" to be blank if the previous row says "Invalid Value" but show the data if there is data in there like the circled cells.
