Help writing a formula that checks several different items

Question

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

QuickBaseCoachD · Answer

Try thisIF([Department or Group] = "CCNA Customer Team � FSOP" andContains(ToText([Tools]), "MFE")andnot [Need Top 5]), "sec-idm-ccna-ssas-mfe-customer")

Sign up

Login to the community