Sorry if this has been answered before but I spent a good chunk of this afternoon searching and couldn't figure it out.
I'm trying to have a cell (let's say A1) be blank if there is any sort of text in another cell (B5). B5 has a formula in it that returns some info from another sheet, but I want the cell B1 to show in A1 if B5 is blank. If B5 has its reference, I want to A1 to not return B1. I'm trying to do something like in A1: =if(istext('othersheet!'B5),"", othersheet!'B1). Problem is it always shows the text, I'm assuming because it's got the formula in it.
This issue seems like something I'd have figured out already, but I can't. Can someone please point me in the right direction. I'm assuming it'll be a smh fix, but I appreciate any help!
I'm trying to have a cell (let's say A1) be blank if there is any sort of text in another cell (B5). B5 has a formula in it that returns some info from another sheet, but I want the cell B1 to show in A1 if B5 is blank. If B5 has its reference, I want to A1 to not return B1. I'm trying to do something like in A1: =if(istext('othersheet!'B5),"", othersheet!'B1). Problem is it always shows the text, I'm assuming because it's got the formula in it.
This issue seems like something I'd have figured out already, but I can't. Can someone please point me in the right direction. I'm assuming it'll be a smh fix, but I appreciate any help!