Forum Discussion

Hpaul's avatar
Hpaul
Regular Visitor
6 years ago
Solved

Conditional Column with multiple IFs and Else against multiple columns

Hi I am trying to create a conditional column with multiple possible results. I keep getting "Token Comma Expected" I go to Custom Column , and add this:

if [Dependents] >0 and Text.Contains([Applicant Name] "&" ) then "Family"
else if [Dependents] =0 and Text.Contains([Applicant Name] "&" ) then "Couple"
Else "Single"


Any help is much appreciated!! I suspect the answer is simple and I am losing my hair over it.
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    I believe you want this:

     

    if [Dependents] >0 and Text.Contains([Applicant Name], "&" ) then "Family"
else if [Dependents] =0 and Text.Contains([Applicant Name], "&" ) then "Couple"
Else "Single"

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    I believe you want this:

     

    if [Dependents] >0 and Text.Contains([Applicant Name], "&" ) then "Family"
else if [Dependents] =0 and Text.Contains([Applicant Name], "&" ) then "Couple"
Else "Single"