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.

Formula headache - Do not show SUM result if a cell in this SUM is left empty -

05/28/15 Edited 12/09/19

For an event budget I've added a column invoice.

The SUM =SUM([Subtot inc BTW]8 - Factuur8) compares the quotation with the invoice
However I'd like to find a way that the column only shows the result of the SUM after an invoice ammount is typed in. Since a lot of cells are left blank in the column invoice the above SUM will show the result of the quotation compared to the blank cell, thus showing a big difference. Is there a formula that will not display the SUM if a cell in this SUM is left empty ?

Comments

  • JamesRJamesR ✭✭✭✭

    =if(isblank(cellref),0,cellref-cellref)

     

    As a note your original calculation did not need the sum function.

    =cellref-cellref would have given you the same answer.

This discussion has been closed.