Countifs with special requirement

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!