+5Hello,
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 error for the way I did the formula but its not counting when the two fields on a record have the "contains" word.
If((Contains([Account Name],"Wire" & Contains([Funding Indicator Name],"ASC"))),1,0)
Appreciate any suggestions. Thank you
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")
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
