function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jeremy Evans 9Jeremy Evans 9 

Help with formula field

I'm trying to edit my formula field to only make it trigger if the List_A_Document__c picklist field = "List B and C Provided".

Can anyone help?


IF(Expiration_Date_of_List_C_Document__c > Acquisition_On_boarding_Application__r.Start_Date__c, 'No', 'Yes')

TIA

 
Dave ShulmanDave Shulman
Just wrap the formula you have in another IF statement saying if the condition you listed above, run this formula, otherwise just leave the field blank.  Let me know if this worked.

IF(TEXT(List_A_Document__c) = "List B and C Provided",
IF(Expiration_Date_of_List_C_Document__c > Acquisition_On_boarding_Application__r.Start_Date__c, 'No', 'Yes'),
"")