Formula using Contain
Hello, I'm trying to count how many records I have that have for Field "Account Name" that contains the work "Wire" and the Field Name "Funding Indicator Name" that contains ASC. I'm not getting an...
Forum Discussion
Syntax is wrong. Try this:
If(
Contains([Account Name],"Wire") and Contains([Funding Indicator Name],"ASC")
,1,0
)
If this is a checkbox formula, you can also shortcut by only giving it the true option and eliminating the If statement all together. ie:
Contains([Account Name],"Wire") and Contains([Funding Indicator Name],"ASC")