Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Help writing a formula that checks several different items

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
  • 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")