I have a picklist field for "Interview Applicable" with the choices being "Yes" or "No". I also have a date field for "Scheduled Interview". I have a third field that is a text field. I'm trying to write a formula for the text field that will give me "NA" if Interview Applicable is "No" and the Scheduled Interview date if Interview Applicable is "Yes". I keep tweaking the formula but continue getting a syntax error message. Below is one version of the formula I've tried. Any help is greatly appreciated!
IF(ISPICKVAL(Interview_Applicable_c, "No"), "NA", IF(ISPICKVAL(Interview_Applicable_c, "Yes"), "Scheduled_Interview_c"))