Countifs with special requirement



I need to use countifs to count the number of calls made to customers today.

In my example, Touch 1 and Touch 2 are calls today, however I also need some filtering with user input.

The criteria are as follow:

  1. Date equals to "Free Text Date" of 20/04/2020 (X1)
  2. Salesman equals to "Free Text Salesman" Peter (X2)
  3. Only Touch 1 and Touch 2 are considered as calls

I was trying =COUNTIFS(Stage:Stage, ("Touch 1" OR "Touch 2"), Salesman:Salesman ("X2"), Date:Date ("X1"))

X1 and X2 should be freely populated by users of the sheet without changing the code


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!