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 -
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 ?