Visible if calculated field with 2 options

Hi all 

I am trying to make a field visible if a field called Install/SO equals "Supply and Fit" or "Supply Only" - how do i write the calculation for this as i only know how to do this for one parameter. 

equal($pr_project_type_c,"Supply and Fit")

how do i add it to include "Supply Only" as well?

thanks so much in advance

  • hi, you can use the isinlist create list formulas

    isInList($account_type,createList("Customer","Partner","Investor"))

    so if you reference the field and then add in all values in the create list as above or rough example below

    isInList($pr_project_type_c,createList("Supply and Fit",""Supply Only"))

    support.sugarcrm.com/.../

  • Hi Penny,

    I love Lee's answer.

    If it is just the two options, or if there are multiple fields you are assessing, you could alternatively use an OR formula, like this:

    or(equal($pr_project_type_c,"Supply and Fit"),equal($pr_project_type_c,"Supply Only"))

    Regards,
    Patrick McQueen
    Director, SugarCRM Support