Forum Discussion

Hadill's avatar
Hadill
Icon for Helper I rankHelper I
4 years ago
Solved

If-else-else Error

I tried many ways to write the If- else quiery, and ever time I get the same error an I dont know the reason, I think I apply the right quirey. Is anybody have any explanation for that?   Thanks i...
Interesting Links
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Hadill ,

     

    Try pasting this into a new custom column window:

    if [Funnel Status] = "Booked" or [Funnel Status] = "Signed" or [Funnel Status] = "Committed" then "Forecast" else "Active"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Hadill ,

 

Try making the following changes to remove the error:

 

1) Make sure that your third reference to [Funnel Status] is spelt correctly.

2) Make sure there is a space between "Committed" and 'and'

3) Make sure the keyword 'if' is lower case

4) Remove the semicolon ';' at the end

 

I also think you will need to correct your evaluation as a single field can't be "Booked" AND "Committed" AND "Signed" all at the same time - you may need the OR operator here.

 

Pete