Pivot table with countifs using multiple criteria


Hello All,

I am trying to build a pivot table using the countifs formula that looks at a spreadsheet containing two various criteria - one is by line of business and the other is if a selection = Yes from a drop down menu - they are in two separate columns but within the same spreadsheet and the pivot table is its own spreadsheet. I had to add in a test column and insert a yes or the countifs formula I have counts every single line. The counts seem to switch to the correct counts if I have the test line in. Please see below for the current formula I have going:

=COUNTIFS({FutureMakers: Managers+ Range LOB}, [Primary Column]@row, {FutureMakers: Managers+ Range Selection Status}, {FutureMakers: Managers+ Range Yes})

Without the test column marked as yes the counts look something like this:

TS 123

CS 321

AS 456

ICS 657

CT 789

But with the test column marked as yes the counts look like this:

TS 0

CS 0

AS 0


CT 0

The hope is that as selections are made and marked as yes the counts will update on an ongoing basis. This happens as long as the test column is in place but I'd love to not have to use that moving forward.

What am I missing? Please help! Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!