Unable to update Estimate Worksheet with negative amount

Issue/Symptom/Question

We would like to be able to delete multiple costcodes for a job that were entered incorrectly, and need to know whether adjusting the estimate amount to zero through an Estimate Worksheet upload would accomplish this.  We've attempted to enter negative amounts to the costcodes we want to delete, but when we upload the file, the negative amounts become zero instead.  

Applies To

Project Management > Estimates > Estimate Worksheet 

Resolution/Fix/Answer

The spreadsheet contains an incorrect format for these negative amounts;  the negative amount was entered with parentheses and commas, rather than a negative (minus) sign, no commas;  

  • (38,600.00) should be entered as -36000.00 
  • The Amount columns should be formatted as Number, rather than as General.
  • OR, the cells formatted as General need to be entered with a minus sign, and no comma delimiters.

 


Spreadsheet entry changed to correct -31833.00 and was uploaded correctly as a negative costcode line entry, adjusting the cc amount to zero.

Cause 

Incorrect Excel spreadsheet column amount entry;  column identified as General (allowing any format) and was individually typed in as (36,833.00)