I've added a picklist field "Lease_Lease_Assign_Applicable__c" with the choices being "Yes" or "No". There is a checkbox field "Lease_Assignment_Received__c" that I will also use. This field has been used for a few years so I can't change the field type. I'm trying to write a formula for a third field (Text) that will give me "NA" if Lease/Lease Assign Applicable is "No" and "Checked or Yes/Unchecked or No" as applicable. Below is the formula I've tried and the error message I received. I'm guessing there is an issue with converting a checkbox field to text. Any suggestions are greatly appreciated!
IF(ISPICKVAL(Lease_Lease_Assign_Applicable__c, “Yes”), TEXT(Lease_Assignment_Received__c), “NA”) Error: Syntax error