I need to create a fomula field that will show a set bit of text if my one of my Date/Time fields is blank but the other one has a value.
I am really bad at formulas but I tried this and the syntax is fine:
IF( AND(ISBLANK(End_Date__c),NTQ_Effective_End_Date__c >= NOW()) , "", "NTQ Active")
The field is still showing NTQ Active for records that have both dates filled in, or records i put a NTQ_Effective_End_Date__c date in and then removed it
6 risposte
please try the below
IF(
AND(
NOT(ISBLANK(End_Date__c)),
NOT(ISBLANK(NTQ_Effective_End_Date__c))
),
'NTQ Complete',
IF(
AND(
NOT(ISBLANK(NTQ_Effective_End_Date__c)),
ISBLANK(End_Date__c)
),
'NTQ Active',
NULL)
)
I have assumed you want the formula to return a blankvalue if the End Date is not blank and NTQ Effective End Date is blank.
