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?

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