Calculated Field if value empty

Hi Cheryl Alderson

Perhaps you can update the formula this way:

ifElse(equal($build_commencement_date_c,""),addDays(build_stage_revised_start_c,$build_stage_days_slab_c),

ifElse(not(equal($build_commencement_date_c,"")),addDays($build_commencement_date_c,$build_stage_days_slab_c),0))

Hi Andre,

Thanks for your guidance!

Updating the formula to your suggested version returns the error:

  Invalid Formula: The formula must be of typedate

The formula is contained in a date field.

The fields in the formula are Data Type:

• Date ($build_commencement_date_c)
• Date (build_stage_revised_start_c)
• Integer ($build_stage_days_slab_c)

Do you now why this error is occuring?

You are right Cheryl Alderson! Because of that you can not implement a regular sugarLogic but instead a Dependency SetValue. Inside a sugarLogic you need to return the field type according to the field being calculated, but inside a Dependency SetValue you can set the triggers which will calculate, so you can only calculate if the appropriate fields are set.

Regards

You are right Cheryl Alderson! Because of that you can not implement a regular sugarLogic but instead a Dependency SetValue. Inside a sugarLogic you need to return the field type according to the field being calculated, but inside a Dependency SetValue you can set the triggers which will calculate, so you can only calculate if the appropriate fields are set.

Regards