Help writing a formula that checks several different items

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
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
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,786 Points 50k badge 2x thumb
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")
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb
Thank you.