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
ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago
I've tried each of the above and the check box checked. But my original formula still doesn't work.
Could it be the IF? Do I not need that part anymore?

This is what I have
If([Related Department or Group] = 3 and Contains(ToText([Tools]), "MFE"), "sec-idm-ccna-ssas-mfe-cbsalldata")&

Should it be
[Related Department or Group] = 3 and Contains(ToText([Tools]), "MFE", "sec-idm-ccna-ssas-mfe-cbsalldata")&