CUSTOMER ZONE

Error: Formula is not valid.

Find resources designed to help you get the most from Replicon

Scenario:
Web TimeSheet administrator creates a new custom formula as shown below but receives an "Formula is not valid" error message even when there is no notable errors in the formula.
BillableHours – NonBillableHours

Cause:
The formula was edited using Microsoft Word and the Minus symbol used in the formula, in the above scenario was converted to Hyphen by Microsoft Word and was copies over to the Web TimeSheet custom columns. Microsoft Word does not use plain text characters, they may use special character which the Web TimeSheet custom column will not be able to interpret hence the error.

Resolution:
One of the following steps can be used to rectify this issue,

  • Print the Word document to a PDF file and then copy and paste the formula from the PDF file to Web TimeSheet.
  • Copy the formula to Notepad and then copy the same formula from Notepad and paste it over to Web TimeSheet.
  • Manually type the formula in Web TimeSheet.

     

Start a free Replicon trial today based on your business needs

Start Free Trial