OK....maybe an easy one. I can't get it to work the way I want to.
I need to update the following formula: =IFERROR(('Projects'!M10),"")
In a workbook, I am referencing a different sheet that has all of the formulas and links in to to another sheet.
I need the formula to return a blank if there is a "0" (zero) and or an error in the field. What's happening now, is its showing a zero in the field and it just needs to be blank.