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),



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





(4) Answers