Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF(AND

Options
edited 12/09/19

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>

• ✭✭✭✭✭✭
Options

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, "")

• edited 02/14/17
Options

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()))

• ✭✭✭✭✭✭
Options

=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

This discussion has been closed.