Sign in to join the conversation:
In the attached sheet an error is showing in my IF(AND statement? [Current Month Sales] shows $0.00 instead of a "" (Blank cell). Thanks in advance
<IFRAME WIDTH=1000 HEIGHT=700 FRAMEBORDER=0 SRC="https://app.smartsheet.com/b/publish?EQBCT=fccbf4d16b7442f9bd0160a985e4e494"></IFRAME>
One of your parenthesis is off. you need to move the ")" to from the end to right after "Heath Sanders".
The correct statement is.
=IF(AND([Invoiced Paid]2 = 1, [Sold By]2 = "Heath Sanders"), [Value of Jobs]2, "")
Thanks Brett, that work great.
You dont know how to return a blank cell instead of a $0.00 for the fomula below by any chance ?
=SUMIFS([Value of Jobs]2, [Sold By]2, "Heath Sanders", Status2, "WON", Result2, 1, [Sold Date]2, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]2, IFERROR(YEAR(@cell), "") = YEAR(TODAY()))
=IF(SUMIFS([Value of Jobs]2, [Sold By]2, "Heath Sanders", Status2, "WON", Result2, 1, [Sold Date]2, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]2, IFERROR(YEAR(@cell), "") = YEAR(TODAY()))=0,"")
Craig
