Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 309 subscribers
  • Views 465 views
  • Users 0 members are here
Related content from around SugarClub

How to use : IFelse Along with AND

saagar vashisht

When Status = Closed Won, I have 3 dropdown fields Appearing. All the 3 dropdown fields have the same list value. Value, A,B&C. Now, If Status is Closed Won and DropDown1 = A, then DropDown 2 and 3 Should not show Values A. DropDown 2 Should Show Values B and C and then When Drop Down 2 = B then DropDown 3 should Default to C. Is this Possible with IFELSE along with AND function?

  • 0

    In your dropdowns. set the dependency to use the previous dropdown to choose which are the available values.

    DropDown 2 would depend upon DropDown 1, etc

  • 0 in reply to Jeff Bickart

    Hi Jeff, Thank you for your reply.
    I did try that initially, 

    For the DROPDOWN 1 i Set it to be dependent on Parent Being Status. and then, If Status = Closed won, It will give me all the 3 options in Dropdown 1 which is A, B & C. Now I can set Dropdown 2 to be depending on Parent Field being DropDown 1, I can distribute the dropdown Values to be selected which means, If DropDown 1 was A then DropDown 2 should Display B & C and IF DropDown 1 was B then DropDown2 should show A&C and so on. 

    But the issue I am really facing is with DropDown 3. because this has to be dependent on DropDown1 and DropDown2. Which means If Dropdown1 = A and DropDown 2 = B then DropDown 3 should show C or IF DropDown 1 = B and DropDown 2 = C then Drop Down 3 should Be A, Does that Make sense?

    I believe there would be nestedIF formula or a IFELSE With AND formula for the Dropdown 3 field.

    *PS, Dropdown 3 can be a Text field if required

    Thanks,