'Required If' formula with 2 conditions - Multiple Statuses and Assigned User Attribute

Hi Sheldon Pereira ,

Welcome to SugarClub! The best practice for validating on one of many different values is to use the isInList function in conjunction with the createList function to define all potential values. There should be no need to do a ifElse with your formula since you only want the field required if both your conditions are satisfied. You just need to begin the formula with a function that natively returns true or false as a result (e.g. and). The formula should look something like this:

and(
    isInList(
        $status,
        createList(
            "Discussion",
            "Inspection",
            "Considering Offer",
            "Documents Requested"
        )
    ),
    equal(
        related(
            $assigned_user_link,
            "business_unit_c"
        ),
        "SYCF"
    )
)

Let me know how it works for you!

Chris

Hi Chris,

Thank you for the prompt response. Big Fan!

I did look at 'isinlist' but could figure out the exact formula.

I've given this a go. However, the field is not longer required under any status or business unit

Hi Sheldon Pereira ,

I tested in a stock instance of Sugar and the formula works as expected, so here is what I recommend checking:

1. Go to Admin > Studio > Leads > Fields > Lead Status. Edit the dropdown list and ensure the key value (i.e. the value in brackets) is exactly what you have in your formula. The value is case-sensitive. The formula should not be using the display value. 
2. Similarly for business_unit_c field in the Users module, check to make sure the value exactly matches (case-sensitive here too) whether that field is a dropdown or text field. 
3. Since your screen is showing a new lead user creation, ensure the assigned to user on the lead is a user with the SYCF business unit. 

If that doesn't help, please provide a screenshot of your current Lead Status dropdown list from Studio as well as the configuration (and if applicable, dropdown list) of the Business Unit field on the Users module.

Chris

Hi Chris Raffle 

Thanks for that. I'll get on that right away.

Regards,

Sheldon

Hi Chris Raffle 

Thanks for that. I'll get on that right away.

Regards,

Sheldon