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

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

Hello BA, thanks for your reply !

 

I fixed my queiry as per your comments, but I still have the same issue. 

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

    Hi Hadill ,

     

    Can you post the code as it appears now after the changes please?

     

    Pete

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

      Hi BA_Pete 

       

      here we are, I tried to change the code body.

      I was wondering if there any thing have to be done with the settings to enable this case?

       

       

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        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