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

Heath Sanders
edited 12/09/19 in Archived 2017 Posts

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>

Comments

  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

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

  • Heath Sanders
    edited 02/14/17

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

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    =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.