Unrecognized Guid format.

I'm getting the error Unrecognized Guid format. when trying to insert into the leads entity in CRM2016.

 

I have narrowed this down to a calculated field which returns customer type.  In the instance where I am seeing an error the formula is returning an empty string.  The formula is:

 

IF(S37 = 0 , "",

IF( ISERROR(CustomerTypeGUID),

IF( LtdCoBusiness=1,MS1GUID,MS2GUID),

 CustomerTypeGUID))

 

I think the reason is the empty string rather than returning null.  Can anyone advise please?

 

Thanks,

Sally

 

(4) Answers

Login