Countif and Contain Cross Sheet reference formula issues


Hi, looking for some help with a formula...mine keeps coming back as 0

I am trying to count how many times a Model# shows up in another sheets column that matches a cell in the Model row of my first sheet by using the Countif Contains formulas.

Here is what I am using.

=COUNTIFS({Selling Used/Consignment Sheet Range 2}, Model@row, {Selling Used/Consignment Sheet Range 2}, CONTAINS(Model@row, @cell))

Thanks in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!