Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Formula using a text list field was working and now isn't

I have a multi-select text list field [Tools] that I am using in a formula. When items in the field are selected another field shows corresponding information. The formula below has been working for s...
App builders
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
This syntax is correct

If(
[Related Department or Group] = 3 and Contains(ToText([Tools]), "ASR (Legacy)")
and [Need Advanced Search] = "No", "sec-idm-ccna-mstr-asrlegacy-cbsalldata")

So if that is not working then the data in the fields is not what you expected.   For a record that is not working, what is in the field 

[Related Department or Group]

 and what is in the field

[Need Advanced Search]

Note that the "No" will be case sensitive, for example if the data has "no", then that will not be true.