Discussions

Expand all | Collapse all

Help writing a formula that checks several different items

  • 1.  Help writing a formula that checks several different items

    Top
    Contributor
    Posted 06-25-2018 16:24
    I want to show the text "sec-idm-ccna-ssas-mfe-customer" when [Department or Group] is "CCNA Customer Team ? FSOP" and [Tools] is "MFE" and [Need Top 5] is not checked.

    [Department or Group] is a Text Lookup field
    [Tools] is a Multi-select Text field
    [Need Top 5] is a Checkbox

    What is the best way to right this?

    Thank you


  • 2.  RE: Help writing a formula that checks several different items

    Posted 06-25-2018 16:43
    Try this

    IF(
    [Department or Group] = "CCNA Customer Team � FSOP" 
    and
    Contains(ToText([Tools]), "MFE")
    and
    not [Need Top 5]), "sec-idm-ccna-ssas-mfe-customer")


  • 3.  RE: Help writing a formula that checks several different items

    Top
    Contributor
    Posted 06-25-2018 18:46
    Thank you.