5

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"))
2
  • I tried the formula below but received the following error message: Error: Field Interview_Applicable__c may not be used in this type of formula. Any suggestions? Thanks in advance!
    – Lynn
    Dec 9, 2013 at 23:06
  • 1
    What is the type of the formula field?
    – Mark Pond
    Dec 10, 2013 at 1:29

1 Answer 1

6

First thing, which may have just been accidental when writing your question is that those custom fields should have two underscores in their name _ _ c.

Second, this should work for you.

IF(ISPICKVAL(Interview_Applicable__c, "Yes"), 
    TEXT(MONTH(Scheduled_Interview__c)) + "/" +
    TEXT(DAY(Scheduled_Interview__c)) + "/" +
    TEXT(YEAR(Scheduled_Interview__c)), "NA")

If the picklist value is 'yes' it converts the date field value into text and if it is 'no' any other value, you receive 'NA' as the result of the formula.

NA


Date
This formula is of the type Text

Formula Definition

5
  • Got it working. Thanks so much!!! Is there any way to change the formatting of the date in the formula field so that it matches the formatting in Scheduled Interview?
    – Lynn
    Dec 10, 2013 at 20:16
  • @Lynn, I updated the formula to demonstrate splitting the date into the year, month and day components.
    – Mark Pond
    Dec 10, 2013 at 22:26
  • @Lynn did this solution work for you?
    – Mark Pond
    Dec 11, 2013 at 16:22
  • 1
    It worked. Thanks again!! You don't know how helpful this has been!
    – Lynn
    Dec 11, 2013 at 19:21
  • Glad to hear that it worked for you! If you could click the 'Accepted Answer' checkmark button (under the voting buttons) on this answer that would be much appreciated.
    – Mark Pond
    Dec 11, 2013 at 19:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .