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 
Options
MikeChap
✭✭
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 ?
Tags:
Comments

=if(isblank(cellref),0,cellrefcellref)
As a note your original calculation did not need the sum function.
=cellrefcellref would have given you the same answer.
This discussion has been closed.