Formula help

Paula Cosentino

I have some columns with formulas that pull in information (if information is available).

helper row.JPG

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.

Paul Newcome

Try this...

=IFERROR([2nd network helper column - do not delete]@row, "")

Paula Cosentino

Paul - you are my hero. I can't tell you how many iterations I had tried of that. It works perfectly. THANK YOU!!!😀

Paul Newcome

Try this...

=IFERROR([2nd network helper column - do not delete]@row, "")

Paula Cosentino

Paul - you are my hero. I can't tell you how many iterations I had tried of that. It works perfectly. THANK YOU!!!😀

Paul Newcome

Happy to help. 👍️