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...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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")