Ask Search:
Aaron PersichAaron Persich 

Numeric Formula

Hello,
 
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.
 
Thanks,
 
Aaron
 
Best Answer chosen by Aaron Persich
Sedoud BoussadSedoud Boussad
It depends if you want to have null or 0 but yes it works :)

User-added image

All Answers

Aaron PersichAaron Persich
Hi There,

There is no NumericField_c.  The field I am trying to create is a numeric formula field based off a date field. 
Aaron PersichAaron Persich
I Think this might work
IF(NOT(ISBLANK(Lead_MQL_Date__c)), 1 ,NULL)
Sedoud BoussadSedoud Boussad
Hi Aaron;
Try this :
IF(NOT(ISBLANK(Lead_MQL_Date__c)), 1 ,0)
Sedoud BoussadSedoud Boussad
It depends if you want to have null or 0 but yes it works :)

User-added image
This was selected as the best answer
Aaron PersichAaron Persich
Thanks, I want it to be blank