Using Countif to check for two sets of criteria in same row

AnthonyRing360
edited 02/16/22 in Formulas and Functions

I need to compare that a range meets both of the following criteria:

1 - Range 1 includes a specific value contained in a different cell

2 - Values in Range 2 contain a string of text

My formula looks like this but isn't working

=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell)) , ({Unique Call Log Range 1}, FieldName@row)

I can break it apart so that either of the criteria counts individually but when I try to make it so that it only counts when both criteria are met, it fails.

These two formulas work on their own

=COUNTIF({Unique Call Log Range 2}, CONTAINS("TEST1", @cell))

=COUNTIF({Unique Call Log Range 1}, FieldName18)

But I can't figure out the formula to only count if both criteria are met in the same row.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!