I am trying to set a numeric field to “1” if a date field is not equal to blank but I am not sure how to create the formula. I need something like.
IF(NOTBLANK, Lead_MQL_Date__c then populate it as a “1”
Any advice is much appreciated.
There is no NumericField_c. The field I am trying to create is a numeric formula field based off a date field.
IF(NOT(ISBLANK(Lead_MQL_Date__c)), 1 ,NULL)
Try this :
IF(NOT(ISBLANK(Lead_MQL_Date__c)), 1 ,0)