Quick Links

Reply To: result as #error

Home Forums Discussion result as #error Reply To: result as #error

Sai Prasad
  • Community Leader
  • Forum Pro

#Error is the result of invalid date returned formula. So, replace the formula of that column with IIf(IsDate([Actual Start]+[Actual Duration]/480+Duration1/480-1),[Actual Start]+[Actual Duration]/480+Duration1/480-1,[Finish]). This uses IsDate function to check if the formula returns valid date or not and accordingly uses the calculated value or the finish date. Hope this helps.